1,540 questions with Microsoft 365 and Office | Excel | For business | Other tags

Sort by: Updated
2 answers

how to make adresse book in excel sheet to control the formula present in many sheets having filter formula buit init.

I have one situation I have two folders folder_1 and folder_2, Folder 1 ([DB_Data_Collectives_2.xlsm]) have one excel sheet_1 : S1 Folder 2 have differnt excel sheet_2 Excel 2 have Filter forrmula in one cell as below …

Microsoft 365 and Office | Excel | For business | Other
asked 2026-09-20T11:17:18.24+00:00
Chaturvedi, Santosh 430 Reputation points
answered 2026-09-20T13:18:41.71+00:00
Marcin Policht 108.3K Reputation points MVP Volunteer Moderator
2 answers

power automate in excel

how do i enable power automate in excel since i want excel to automate sending emails for me

Microsoft 365 and Office | Excel | For business | Other
asked 2026-09-10T21:19:40.49+00:00
Jessie Red 0 Reputation points
commented 2026-09-18T15:13:42.0366667+00:00
Lin v 1,455 Reputation points Independent Advisor
2 answers One of the answers was accepted by the question author.

how to collect the values from differnt sheets to one and sort them with simialr values.

(Note all values are fake not real) Hello -- I have one case. I need to paste the following content in sheet when is placed in starting seee below-. All the tabs (sheet, collective1,2,3,4...9)are in one sheet only. The values from tab Collective _1,…

Microsoft 365 and Office | Excel | For business | Other
asked 2026-09-17T10:06:34.27+00:00
Chaturvedi, Santosh 430 Reputation points
commented 2026-09-18T15:01:20.53+00:00
Alina Le 5,080 Reputation points Independent Advisor
2 answers

How to fix this error and how can i start back my Microsoft Excel app?

This is the Screen shot of the error , please provide a solution to fix this?

Microsoft 365 and Office | Excel | For business | Other
asked 2026-09-16T05:19:26.7366667+00:00
Kshitij Shirodkar 0 Reputation points
commented 2026-09-17T11:49:41.2866667+00:00
Ana Le 2,600 Reputation points Independent Advisor
1 answer

Copilot available in word, powerpoint, outlook but not in excel and teams

I can see the copilot icon on right bottom of word and powerpoint. I can also see copilot in the outlook ribbon. But unable to find copilot icon in excel and teams. It is neither available as right bottom icon nor in the ribbon.

Microsoft 365 and Office | Excel | For business | Other
asked 2026-09-13T12:21:03.34+00:00
Jigisha Thakkar 0 Reputation points
commented 2026-09-15T10:27:20.5566667+00:00
Helen Luu 2,865 Reputation points Independent Advisor
1 answer

Excel Online functionality of Office Script buttons on protected sheets

Experiencing a problem with Office Script buttons in Excel Online. Previously, these buttons worked correctly on protected sheets, but now they only function when the sheet is unprotected. This change has disrupted my workflow, as I need to unprotect the…

Microsoft 365 and Office | Excel | For business | Other
asked 2026-08-27T15:01:20.8966667+00:00
erinwhi 0 Reputation points
commented 2026-09-14T14:57:55.0866667+00:00
1 answer

Copilot now working in excel

Error----I'm sorry, but there was an error processing your request. Tried below Save the workbook to OneDrive/SharePoint and turn on AutoSave Copilot in Excel requires the file to be saved to OneDrive or SharePoint. Ensure AutoSave = ON. Close…

Microsoft 365 and Office | Excel | For business | Other
asked 2026-09-11T07:41:04.22+00:00
Snehal Sule 0 Reputation points
edited an answer 2026-09-12T11:10:13.83+00:00
Daniel-Vo 6,450 Reputation points Microsoft External Staff Moderator
3 answers

Why I cant able to copy the datas in a sheet in excel

Microsoft 365 and Office | Excel | For business | Other
asked 2026-09-09T10:18:30.14+00:00
Manokaran Vijay Prabhakaran 5 Reputation points
answered 2026-09-12T04:14:03.2833333+00:00
EmilyS_726 29,200 Reputation points Volunteer Moderator
2 answers One of the answers was accepted by the question author.

Shape/Button hyperlinks on protected sheets worked last week in Excel Online but are now completely unclickable unless the sheet is unprotected."

Shape/Button hyperlinks on protected sheets worked last week in Excel Online but are now completely unclickable unless the sheet is unprotected." This is major for our company and we have hundreds of users with "Menu" buttons on the first…

Microsoft 365 and Office | Excel | For business | Other
asked 2026-09-09T19:46:36.9733333+00:00
Chris Botha 20 Reputation points
commented 2026-09-11T21:01:33.64+00:00
Kai-L 19,155 Reputation points Microsoft External Staff Moderator
2 answers

Excel 2016 on Windows 11 - Copy, Paste, and Drag & Drop Not Working Across Multiple Systems

Hello Team, We are facing a critical issue with Microsoft Excel 2016 across our organization. Environment: Microsoft Office 2016 Windows 11 Issue affecting multiple systems (not limited to a single user or device) Issue Details: Copy (Ctrl+C)…

Microsoft 365 and Office | Excel | For business | Other
asked 2026-09-10T04:42:33.9433333+00:00
Praddyumn Singh 15 Reputation points
commented 2026-09-11T02:47:45.68+00:00
Darren Bruce 1,650 Reputation points Independent Advisor
2 answers

Page Break Preview within shared workbook

The functionality of Xcel within a shared workbook seems different than that of a non-shared workbook. Where is the page break feature? Why are the various tools' icons so different looking than that of regular Xcel?

Microsoft 365 and Office | Excel | For business | Other
asked 2026-09-02T14:36:55.0366667+00:00
Joe J 20 Reputation points
commented 2026-09-04T11:59:03.6866667+00:00
Helen Luu 2,865 Reputation points Independent Advisor
1 answer

Excel "Enable Editing" (Protected View) keeps re-prompting every time on Windows Server 2022, but works correctly on Windows 11 for the same file

Environment Product: Microsoft 365 Apps for business, Current Channel Version: 2607 (Build 20228.20124, Click-to-Run) Affected machine: Windows Server 2022 Comparison machine (working correctly): Windows 11, same Microsoft 365 Apps version Office…

Microsoft 365 and Office | Excel | For business | Other
asked 2026-08-17T13:09:14.63+00:00
Laxman singh 1 Reputation point
edited an answer 2026-09-04T00:34:23.8833333+00:00
Michelle Nguyen 1,510 Reputation points Independent Advisor
2 answers

Office Script Buttons in Excel on the Web don't work

We use buttons to run office scripts in excel on the Web. the button keeps on losing its functionality, it becomes a lifeless shape and doesn't respond when pressed. when running the script from the automate tab it works well. The issue is not with the…

Microsoft 365 and Office | Excel | For business | Other
asked 2026-08-24T19:49:04.88+00:00
Anonymous8 90 Reputation points
commented 2026-09-02T17:21:46.7966667+00:00
Kimberly A Grantham 10 Reputation points
1 answer

Excel 2608 vs 2607 – Updated data not reflected in dependent worksheets

Hi Team, We are experiencing an issue in our Excel Office Add-in after upgrading from Excel version 2607 to 2608. Our add-in has a process that updates source data in the workbook and then relies on PivotTables/workbook data to populate values in other…

Microsoft 365 and Office | Excel | For business | Other
asked 2026-08-26T17:33:58.9233333+00:00
Pooja 0 Reputation points
commented 2026-08-28T14:21:22.0733333+00:00
Kristen Tran 1,700 Reputation points Independent Advisor
5 answers

I want 2 attendance tracker one with monthly attendance (absent/ present/ half day) with 2 paid holidays every month and another one weekly attandance for labours payout every sun on attandance. In weekly there three salary slabs. Need salary to be paid

In Column AJ, need how much salary to be paid at the end of month. Also to handle half day In weekly I need output in another sheet where sunday date is monetioned. I need to know how much attendance and how much salary. to select any sunday of…

Microsoft 365 and Office | Excel | For business | Other
asked 2026-04-17T06:03:00.3033333+00:00
Ramesh Garg 0 Reputation points
answered 2026-08-27T16:47:35.51+00:00
Danial 0 Reputation points
1 answer

How to fix Microsoft & word excel 365

I have purchased word excel on company card under my personal work microsoft account . And it has went to the company microsoft account . Some how its mereged and now I have tried to purchase it again under my personal work email it is now saying…

Microsoft 365 and Office | Excel | For business | Other
asked 2026-08-26T12:15:10.9466667+00:00
Michelle Story 0 Reputation points
commented 2026-08-27T14:55:44.6233333+00:00
Julie Huynh 3,425 Reputation points Independent Advisor
1 answer

microsoft office

kenapa excel, word aku gabisa dibuka? tulisannya eror, dan harus diperbaiki, tapi setelah aku pencet "perbaiki sekarang" malah ga ngerubah apapun

Microsoft 365 and Office | Excel | For business | Other
asked 2026-08-04T05:39:43.4966667+00:00
nitaa nita 0 Reputation points
edited an answer 2026-08-26T10:44:26.24+00:00
Nam-D 3,980 Reputation points Microsoft External Staff Moderator
1 answer

Accounting And Finance

Common technical questions to prepare Walk us through the month-end closing process. Explain the difference between accruals and prepayments. How do you perform a bank reconciliation? What would you do if the bank reconciliation has an unexplained…

Microsoft 365 and Office | Excel | For business | Other
asked 2026-08-24T07:35:26.0533333+00:00
Christine Kimuyu 0 Reputation points
commented 2026-08-25T08:12:29.49+00:00
riny 21,520 Reputation points Volunteer Moderator
2 answers

excel AGENT Mode

I have just subscribed to Microsoft 365 Business Premium, i want to use AGENT MODE in excel and would like help activating or accessing this. I am using excel on web, which is ridiculously slow, keeps freezing but thats a separate issue. my browser is…

Microsoft 365 and Office | Excel | For business | Other
asked 2026-08-04T14:31:48.59+00:00
majid khan 0 Reputation points
answered 2026-08-22T09:02:43.2866667+00:00
Ralph Boccalini 35 Reputation points
2 answers One of the answers was accepted by the question author.

Excel formula

I am trying to do a formula on a spreadsheet and need help. Tab 1 - This has column C and Column D Tab 2 - This has the same information but in Column A and Column B In Tab 2 each line in Column C has a unique text title. I want Tab 1 to pick up the…

Microsoft 365 and Office | Excel | For business | Other
asked 2026-08-21T10:39:40.4733333+00:00
Janette Coles 20 Reputation points
commented 2026-08-21T12:53:08.49+00:00
Janette Coles 20 Reputation points