19,731 questions with Microsoft 365 and Office | Excel | For business | Windows tags
Make new excel documents open in active excel if using multiple desktops
Hi. I have 3 desktops with separate instances of excel in each of them. When I open an excel attachment it always goes to the first excel I created even if it is not on the active desktop nor the active excel. Its infuriating as clearly you want it to…
Microsoft 365 and Office | Excel | For business | Windows
Even using text to columns I can't convert 4112025 to a date format, but other dates like 12012025 convert correctly.
Using text to columns I was able to convert some of the dates in my spreadsheet to properly formatted dates. Others did not change at all. This effected only dates that have one digit for the month. Those dates are still formatted as "general."…
Microsoft 365 and Office | Excel | For business | Windows
How to log in to my MS account when I'm locked out?
I need to change my Debit Card that is on file. I've tried countless times but I am not able to log in and I have been locked out. How can I log in?
Microsoft 365 and Office | Excel | For business | Windows
I need an excel formula for the following vacation breakdown
90days= week 6 months = 2 weeks 3 years = 3 weeks 8 years = 4 weeks
Microsoft 365 and Office | Excel | For business | Windows
can anyone help me set up a barcode scanner to display certain aspects on excel?
I'm attempting to set up a Netum (model NT1228BL) barcode scanner. When the barcode is scanned, would like it to display: Name Phone Serial Model Time IN Time Out Also, I would like to have it so they data cannot be manually changed once recorded. …
Microsoft 365 and Office | Excel | For business | Windows
Excel-insert function message
Hi, I m working on a financial model in excel. Whenever I try to link calculations to the model i receive this attached message. How to solve this problem? [Moderator note: personal info removed]
Microsoft 365 and Office | Excel | For business | Windows
Excel pivot tables linked to Access not refreshing after update.
After the KB5072033 updated release on 12/9/2025 Excel pivot tables linked to Access will not allow refresh and receive the "[Microsoft][ODBC Microsoft Access Driver] Operation is not supported for this type of object error" when attempting to…
Microsoft 365 and Office | Excel | For business | Windows
Why does my Excel cannot be open or repair immediately ? it is my first time to open a file here
It says Excel Microsoft is working error so it won't work correclty, while I want to click a Excel file that is sent to me via facebook messenger. In short I can't open and read a file that is sent to me via facebook messenger. Why? It is my first time…
Microsoft 365 and Office | Excel | For business | Windows
How to create a Data Validation List that can be typed into
Hello all, I am looking for some support with creating Data Validation (combi Box). I am looking to understand how I can create a Drop Down List that allows me to type in and Auto-Fill. Then have the ability to select Enter or Tab and move to the…
Microsoft 365 and Office | Excel | For business | Windows
restore a calendar
I had created a calendar within office and deleted it by mistake, now I cannot alter invites associated to that calendar, can you help
Microsoft 365 and Office | Excel | For business | Windows
Issue Opening Embedded Excel Object in Word Document
Hello, I am experiencing an issue when trying to open or edit an embedded Excel object inside a Microsoft Word document. When I double-click the object, Word shows the following error: “The program used to create this object is Excel. This program is…
Microsoft 365 and Office | Excel | For business | Windows
Recover Unsaved Data
I had autosave on the entire time I've had a file open. After I had my computer restarted, it deleted all of my data from today, 12/11, back to 11/12 and I wasn't aware of the change before I clicked off the recover tab when the file opened. Is there any…
Microsoft 365 and Office | Excel | For business | Windows
Product deactivated warning when i am licensed
Hi, Even if my company just renewed the license, Microsoft 365 apps give warning in the attached picture. Only i am getting that warning inmy team. Here is a view from office > ofice account page: Another view from subscription page: I tried to…
Microsoft 365 and Office | Excel | For business | Windows
Trying to Sort by two different columns while using the FILTER function.
I am currently sorting by one column (see below) and it is working as needed. =SORT(FILTER('Score Calculations'!B9:Q38,('Score Calculations'!E9:E38>44)*('Score Calculations'!F9:F38>44),""),16,-1) Here is the source sheet: Here is the…
Microsoft 365 and Office | Excel | For business | Windows
Recover a deleted Autorecovered file
Hi, I opted to not save an auto recovered version of one of my file, and I deleted it. Is there any way I can recover the same file?
Microsoft 365 and Office | Excel | For business | Windows
error'1004': We couldn't copy this sheet
After changing my laptop system language from Chinese to English, I am unable to copy worksheets in an .xlsm file that was created in a Chinese environment. Excel shows the error: If I switch the system language back to Chinese, the issue does not…
Microsoft 365 and Office | Excel | For business | Windows
Nie mogę wprowadzić zakupionego klucza licencji do Office 365 Business Standars
Kupiłem klucz licencji do Office 365 Business Standard - [Uwaga moderatora: usunięto dane osobowe] i nie mogę go aktywować
Microsoft 365 and Office | Excel | For business | Windows
Excel has locked me out of my protected sheet when I am certain I am using the correct password.
I have an excel spreadsheet in which one of the sheets I have protected with a password. Recently I tried to access the protected sheet but it now says the password is wrong - which I know it is is not as I have accessed the sheet in the past. So i then…
Microsoft 365 and Office | Excel | For business | Windows
Smart View is not downloading on my machine
I have tried multiple times to download Smartview and while the download works, its not showing up on excel. I look into add-ins and its not there either. Can you please help with a proper install?
Microsoft 365 and Office | Excel | For business | Windows
How can I get Excel to import data from a site using SSO to log in?
My team has an important tool made of an Excel workbook running on a VBA script. Basically what this tool does is import data from our ServiceNow site and format it into a Word document or an Outlook email. A couple years ago, my organization pushed for…