19,731 questions with Microsoft 365 and Office | Excel | For business | Windows tags

Sort by: Updated
4 answers

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
asked 2025-12-12T17:56:14.1966667+00:00
Mike Asplin 0 Reputation points
answered 2025-12-12T22:19:10.34+00:00
Jay Tr 6,310 Reputation points Microsoft External Staff Moderator
4 answers

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
asked 2025-12-06T16:01:12.11+00:00
KNH 0 Reputation points
commented 2025-12-12T21:59:17.6766667+00:00
Kai-L 7,335 Reputation points Microsoft External Staff Moderator
3 answers

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
asked 2025-12-12T20:56:42.4933333+00:00
Richard Dealy 0 Reputation points
answered 2025-12-12T21:49:26.2733333+00:00
Kai-L 7,335 Reputation points Microsoft External Staff Moderator
2 answers

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
asked 2025-12-12T18:50:33.6333333+00:00
Stephanie Shoemaker 0 Reputation points
answered 2025-12-12T21:16:58.59+00:00
Jay Tr 6,310 Reputation points Microsoft External Staff Moderator
2 answers

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
asked 2025-12-12T18:15:50.0233333+00:00
Carmelo Furnari 0 Reputation points
answered 2025-12-12T20:53:27.7366667+00:00
Kai-L 7,335 Reputation points Microsoft External Staff Moderator
1 answer

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
asked 2025-12-12T18:07:14.97+00:00
Abdulhaki Korbayram 0 Reputation points
edited the question 2025-12-12T19:41:33.7866667+00:00
Ruby-N 6,145 Reputation points Microsoft External Staff Moderator
1 answer

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
asked 2025-12-12T17:39:52.28+00:00
BC 0 Reputation points
answered 2025-12-12T18:22:34.7366667+00:00
Vy Nguyen 7,835 Reputation points Microsoft External Staff Moderator
2 answers

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
asked 2025-12-11T07:46:08.68+00:00
Jessa Canama 0 Reputation points
commented 2025-12-12T15:42:46.7866667+00:00
Tamara-Hu 8,635 Reputation points Microsoft External Staff Moderator
1 answer

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
asked 2025-12-11T13:56:28.4266667+00:00
Chris Murray 0 Reputation points
edited a comment 2025-12-12T15:30:13.1733333+00:00
Tamara-Hu 8,635 Reputation points Microsoft External Staff Moderator
2 answers

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
asked 2025-12-12T13:15:50.4733333+00:00
Goodacre, Mark SUKEP-UPC/T/O 0 Reputation points
edited an answer 2025-12-12T14:57:51.2466667+00:00
Demi-N 9,190 Reputation points Microsoft External Staff Moderator
2 answers

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
asked 2025-12-11T12:57:25.5433333+00:00
Amrit Kaur 0 Reputation points
commented 2025-12-12T14:23:34.4666667+00:00
Nam-D 655 Reputation points Microsoft External Staff Moderator
2 answers

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
asked 2025-12-11T13:48:42.4166667+00:00
Humphreys, Nathan C 0 Reputation points
commented 2025-12-12T14:14:45.8166667+00:00
Phoebe-N 7,030 Reputation points Microsoft External Staff Moderator
1 answer

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
asked 2025-12-12T11:16:41.8+00:00
Elif İntizamoğlu 0 Reputation points
answered 2025-12-12T14:01:23.05+00:00
Demi-N 9,190 Reputation points Microsoft External Staff Moderator
2 answers One of the answers was accepted by the question author.

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
asked 2025-12-11T16:18:10.5166667+00:00
Wright, Paul@CHP 25 Reputation points
edited an answer 2025-12-12T13:57:29.1+00:00
Dana D 0 Reputation points
1 answer

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
asked 2025-12-12T06:40:58.16+00:00
Sharique Azizi 0 Reputation points
edited a comment 2025-12-12T12:02:37.5333333+00:00
Allison-H 5,040 Reputation points Microsoft External Staff Moderator
1 answer

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
asked 2025-12-12T08:40:10.04+00:00
Sandy 0 Reputation points
answered 2025-12-12T11:57:20.4533333+00:00
Tamara-Hu 8,635 Reputation points Microsoft External Staff Moderator
1 answer

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
asked 2025-12-12T09:56:25.56+00:00
Adam Barlak 0 Reputation points
answered 2025-12-12T10:48:00.7+00:00
Henry-N 6,635 Reputation points Microsoft External Staff Moderator
2 answers

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
asked 2025-12-12T03:00:52.8633333+00:00
LZ 0 Reputation points
answered 2025-12-12T04:23:32.5133333+00:00
Darren-Ng 5,880 Reputation points Microsoft External Staff Moderator
4 answers

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
asked 2025-12-09T14:25:03.77+00:00
Bodiwala, Nirali 0 Reputation points
commented 2025-12-11T23:35:47.43+00:00
Bodiwala, Nirali 0 Reputation points
2 answers

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…

Microsoft 365 and Office | Excel | For business | Windows
asked 2025-12-10T22:35:34.54+00:00
ALH 0 Reputation points
commented 2025-12-11T23:25:46.5133333+00:00
Sophie N 8,600 Reputation points Microsoft External Staff Moderator