
42,560 questions with Microsoft 365 and Office-related tags
M365 Licensing for external user v/s normal users
Hi all, Do AD users and external users have access to all features in M365 in terms of licensing? Is there any difference in the features available in any of the workloads to a licensed external users from a licensed AD user - both holding the same…
Microsoft 365 and Office | Development | Microsoft 365 Publishing

Microsoft Security | Microsoft Entra | Microsoft Entra ID
Importing data to excel using a dynamic URL that uses the input of cell a1
Hello, I am starting on excel and I have a ambitious (for me me that don´t now much about excel) request, I want to import certain information to fill a form on excel using a URL. This URL needs to add a client number at the end to access the needed…
Microsoft 365 and Office | Excel | For business | Windows

Excel doesn't see new columns when I want to append several sheets
I had multiple .csv files that I downloaded to Excel workbook as tables on separate sheets. I've added a new Date column to each table, each sheet has a data for each month, so I have 12 tables. After that I want to append all tables so I have the whole…
Microsoft 365 and Office | Excel | For business | Windows

How to get rid of status in one drive?
I have already quit one drive on my pc, but the status icons are still there.
Microsoft 365 and Office | OneDrive | For business | Windows

Table column reference in Excel
I am trying display column elements using "=Tracking[Type]" Tracking is table name and Type is column name. This gives value Error.
Microsoft 365 and Office | Excel | For business | Windows

How to fetch data of more than one column with single click In MS Office?
I am here with a problem and want to get solution of it through your help. I am MS Office user and have multiple records in one file like mix and match jollibee. I have a multiple records in the file and want to fetch different records with single click.…
Microsoft 365 and Office | Install, redeem, activate | For business | Windows
Merge PDF from Word to FoxIt Not Saving
Hello. I'm working with an end user who is needing to use the Merge PDF option in Word to convert documents to FoxIt PDF. He would prefer to use this method because he needs to transfer 500 documents total, and the Print to PDF feature doesn't have the…
Microsoft 365 and Office | Word | For business | Windows

Show/hide the fields based on the condition in jQuery
how to show/hide the otp->textbox and update->button based the onblur SaveProfileName_Email values change. Initially, when the page is loaded the txtProfileEmail and txtProfileName should contains the default values ex:- txtProfileEmail :-…
Microsoft 365 and Office | Development | Office JavaScript API

Developer technologies | ASP.NET | Other
How to make flow so if an item is deleted in Sharepoint it is also deleted in the planner
I am trying to set up a flow in power automate so that if an item in my sharepoint list is deleted then the corresponding task in my planner is also deleted. I already have it set up so that once an item is added in the sharepoint, it will create a task…
Microsoft 365 and Office | SharePoint | For business | Windows

Power Automate: Button that opens an email?
Hello, I was wondering how to create a button on SharePoint that, when clicked, opens a new window with an email pre-addressed with a form. All you have to do is fill out the form included in the body of the email and send it. Is this possible using…
Microsoft 365 and Office | SharePoint | Development

Microsoft 365 and Office | SharePoint | For business | Windows

How to make Microsoft Word the modern theme?
Hi, I recently needed to reset my laptop and reinstall office 365 and powerpoint seem to have reverted to an older version or look at least. My desktop word used to look like this: But now it looks like this: Anyone have an idea on how to fix it? BTW…
Microsoft 365 and Office | Word | For business | Windows

Access VBA References caused compile error
An Access database in Microsoft Office 365, which is up to date, uses references to several other programs, selected in the Tools | References menu in the VBE. It has compiled successfully for several months as it is developed. It then suddenly failed…
Microsoft 365 and Office | Access | Development

Microsoft 365 and Office | Install, redeem, activate | For business | Windows

FORMCHECKBOX field code doesn't render checkbox
I have a word document that contains a FORMCHECKBOX field code I can view by hitting ALT-F9, however when I toggle it to not show the field code, there is no checkbox that appears in its place. Why is this? In our software we insert a checkbox when we…
Microsoft 365 and Office | Open Specifications

Microsoft 365 and Office | Install, redeem, activate | For business | Windows

Internal error while using Excel add-in copyFrom
The following error occurred while copying a short row of coloured empty cells from Q31:AB31 to Y1:AJ1 on a different worksheet. The cells did not contain any data and appear to have been copied successfully before the error…
Microsoft 365 and Office | Install, redeem, activate | For business | Windows
Microsoft 365 and Office | Excel | For business | Windows


How to create a template from a SharePoint list that has multiple column types?
My SharePoint list has 35 columns: 1 choice; 3 multiple lines of text; 12 person or group; and 19 single line of text. When I try to save the list as a template and include content, I get the following error message: Sorry, something went wrong Read…
Microsoft 365 and Office | SharePoint | For business | Windows

Couldn't upload changes: Upload is invalid
Error - Couldn't upload changes: Upload is invalid when creating a new list item in my SharePoint list.
Microsoft 365 and Office | SharePoint | For business | Windows

Why do I have both Office 365 apps for Business and Office 365 apps for Enterprise?
I have a Microsoft 365 business premium license but have both Microsoft 365 Apps for business and Microsoft 365 Apps for enterprise installed on my system plus another Microsoft 365 entry. This occurs only on some computers in our environment where…
Microsoft 365 and Office | Install, redeem, activate | For business | Windows
Error 403: Access Sharepoint using App Credentials in Python
I am trying to access files stored in SharePoint using Python. I have registered the app in Azure Ad and have client_id and client_secret. I have given the read and write permissions however I am still getting 403 error. I am not really sure as to what I…
Microsoft 365 and Office | SharePoint | For business | Windows

Microsoft Security | Microsoft Identity Manager
How to integrate Auth0 login on Desktop Office apps (in an Addin)
Hello, I am currently developing an Addin for Word and it is difficult to finish it because the SSO (Auth0) is working well on the web version and my plugin works wonders however I cannot login on the Windows or Mac version of Word because of the url…
Microsoft 365 and Office | Development | Other

Microsoft 365 and Office | Word | For business | Windows

Microsoft 365 and Office | Excel | For business | Windows

Office-Addin MSAL Single Sign In SSO: How to Refresh the Access Token
Hi, I have developed Office-ExcelAddIn using Angular. I am using OfficeRuntime.auth.getAccessToken() to get the taken for api authentication. After 87min the token expires and ExcelAddIn stops working. If I try to use the getAccessToken() method after 87…
Microsoft 365 and Office | Development | Other
