Recent 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 theFilemenu. In the File menu, click onOptions. 2. An Excel Options dialog box will appear. Go to theAdvancedtab and scroll down to theGeneralarea. Over there checkIgnore 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 date
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
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.
Outlook not updating inbox
I have added a second mailbox to my outlook. It will update when I start in the morning but last email will be like 9 am & will not update again unless it wants to. I have reconnected, shut down outlook, & can not get it to work. On my phone it works fine but on the pc it is like it has a option to check every 8 hours & will not check any other time.Outlook (365) Need Password - Issue
Hi, We are using E3, outlook 365 in our company. Some of our users' outlook stop sync with exchange and ask for password, as shown in below image: to fix the issue, I clear entries in Credential Manager, Delete Temporary Files, unchecked "Use Cached Exchange mode", restart system and check this again. but after some couple of days, outlook again stop sync and ask for password. I'll appreciate for any possible support to fix this issue permanently. Thanks,
Anonymous responses on Office forms: is there any way to have their email or name?
Hi, I have launched acontest for colleagues but all responses came out anonymous (i had incorrectly unselected that option). I need to find out who sendeach of the responses. Is there any way we can find out who is behind each of the anonymous responses I got? Thank you in advance.
How to change bin number/width in a histogram in Excel for Mac (Office 2020)
Hello, I have created a histogram and now I want to modify the width and number of the bins. Can someone please advise? When I select 'format axis' there is no option to modify bin (see attached). I have seen various videos and web pages that show how to do this in Excel 2016 and later, so I am confused as to why bin width/number is apparently hard wired in my Excel (2020 Microsoft 365, Excel version 16.41). Thank you for your help."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 Communityor get support in the Answers community.
Recent Blogs
- As part of our ongoing efforts to streamline and enhance user experiences, we will be retiring the ‘Help me create’ feature on the Microsoft 365 app. This change will affect web endpoints (www.m365.c...Dec 13, 2024
- 2 MIN READThe highly anticipated feature – Forms data sync to Excel is now available in Microsoft Forms. With just one click, you can now easily access all your form responses in Excel for the web a...Dec 13, 2024
