Forum Widgets
Latest Discussions
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.
How do I make excel change the colour of a cell depending on a different cells date?
Hi, How do I make excel change the colour of a cell depending on a different cells date? Turn A2 red if - E2 cell is smaller than todays date Turn A2 yellow with red outline if - E2 cell is equal to todays date Turn A2 clear if - E2 cell is bigger than the current dateCombine 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
Formula or function for IF statement based on cell color
I don't know how to code in VBA but am trying to automate an if/then calculation based on cell color. As shown in the picture, if the colors of the cells in column B are the same as those in Column G across the row, I want to subtract the values in columns F and K in the same row to return the absolute value of the subtraction in column L. If the colors of the cells are different, I want to add the values in columns F and K and return the value in column L. I will have multiple tables of varying numbers of rows where I need to perform this operation. Any help is greatly appreciated.
