Microsoft Excel is waiting for another application to complete an OLE action
Hi there, Whenever I copy paste special in excel, my excel file freezes and after a waiting for a few seconds to few minutes, depending on the amount of data being copy pasted, I get this error 'Microsoft Excel is waiting for another application to complete an OLE action' I tried a few things like this but none help and the problem persists. 1st troubleshooting 1. Open the Excel sheet and go the File menu. In the File menu, click on Options. 2. An Excel Options dialog box will appear. Go to the Advanced tab and scroll down to the General area. Over there check Ignore other applications that use Dynamic Data Exchange (DDE). 3. Restart Excel. 2nd troubleshooting Tried opening Excel in safe mode 3rd troubleshooting Removed all the Add ins 4th troubleshooting Reinstalled MS Office. Can someone help.
Combine data from 2 columns into 1 column
I want to do this, but with 2 columns of data. We have a sheet with area codes in one field and phone numbers in another. I need the 2 pieces of data in one field for a list of 500 phone numbers. Do I have to do them one at a time???? Combine data with the Ampersand symbol (&) Select the cell where you want to put the combined data. Type = and select the first cell you want to combine. Type & and use quotation marks with a space enclosed. Select the next cell you want to combine and press enter. An example formula might be =A2&" "&B2.Excel cannot be open the file 'filename.xlsx' because the file format or file extension is not valid
Hi All, I have a excel.xlsx file saved in my system which has been corrupted .I atleast need to recover the data stores .It is a file of 124 KB and has around 35 worksheets in the workbook .I have tried all possible ways to recover and repair the file .i even tried to extract the data using 3rd party application like stellar,ease of use recover application of excel still i have no luck . The below error message im getting whenever i try to open the file.I even tried to open it through other applications like wordpress,google sheets and so on but nothing works . Thanks and regards , Muthuraman
"all the merged cells need to be the same size" during a Custom Sort
On ASUS StudioBook x64 PC, Windows 10 Pro for Workstations, ver. 20H2 (OS Build 19042.1288)Microsoft 365, EXCEL ver. 2109 (Build 1443020306) ... While attempting to do a custom sort of an EXCEL table of 96,600 + records, I received an error stating "all the merged cells need to be the same size during this operation" Following online help directions for finding merged cells, none were found! (I didn't knowingly create merged cells, but when clicking Options > Format > Alignment, under Text Control, both "Wrap text" and "Merge cells" have their squares filled in with black fill.) The same error occurs when I attempt to sort the field 'editinitl' (A to Z) in the table. The field holds 3-character-long abbreviations of persons name in capital. Why is this message occurring when the suggested find procedure finds no merged cells? Here's the procedure I tried to find the merged cells. Find merged cells You may encounter an Excel worksheets that has merged cells that you don’t know about. This can be frustrating because Excel doesn't sort data in a column that contains merged cells. Following the steps below, you can find all the merged cells in your worksheet and then unmerge those cells. Click Home > Find & Select > Find. Click Options > Format. Click Alignment > Merge cells > OK. Click Find All to see a list of all merged cells in your worksheet. When you click an item in the list, Excel selects the merged cell in your worksheet. You can now unmerge the cells. Need more help? You can always ask an expert in the Excel Tech Community or get support in the Answers community.
