Microsoft Q&A

Office Development

2,873 questions

Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
Development: The process of researching, productizing, and refining new or existing technologies.

Browse all Office tags

2,873 questions with Office Development tags

Sort by: Updated
Updated Created Answers
0 answers

How to make excel sharepoint run in the background using automate script?

I made an auto refresh pivot table, but it only works when Excel in SharePoint is opened (Active), how can I make this run without opening it.

Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
2,873 questions
asked 2023-10-02T03:00:50.27+00:00
Hery Cahyadi - DAD 0 Reputation points
commented 2023-10-04T23:18:07.7733333+00:00
Wamwitha Love 76 Reputation points Microsoft Employee
1 answer

Microsoft 365 apps servicing profile setting to current channel while update the monthly channel

I have created a Servicing Profile in the Microsoft 365 Apps admin center for our devices. I have been adding devices to the profile. Most devices seem to be switching to the Monthly Enterprise Channel, as expected. However, there are many devices that…

Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
2,873 questions
Office Management
Office Management
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Management: The act or process of organizing, handling, directing or controlling something.
1,805 questions
asked 2023-10-02T21:14:14.6166667+00:00
Bejugam Nagraj 0 Reputation points
commented 2023-10-04T21:37:14.1533333+00:00
Bejugam Nagraj 0 Reputation points
1 answer One of the answers was accepted by the question author.

Excelscript performance testing

Hey! I am working on an ExcelScript that extracts data, processes it and generates multiple reports on new worksheets. I've been trying to optimize it for performance but it seems like when I re-run the same script multiple times on the same Spreadsheet…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
946 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
2,873 questions
asked 2023-10-04T03:45:24.9733333+00:00
Brenno Oliveira 0 Reputation points
accepted 2023-10-04T20:58:42.2266667+00:00
Brenno Oliveira 0 Reputation points
2 answers

Customer wants a Developer account

Dear, We have a customer that wants to be able to make push notifications to a windows application. The customer thinks he needs a development account for that, while at our company we use a private account for that, that works aswell. We offered this…

Windows
Windows
A family of Microsoft operating systems that run across personal computers, tablets, laptops, phones, internet of things devices, self-contained mixed reality headsets, large collaboration screens, and other devices.
3,095 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
2,873 questions
asked 2023-08-30T14:37:21.7533333+00:00
Tygo van Riel | hallo 20 Reputation points
commented 2023-10-04T17:32:19.81+00:00
Kelly Bowen-McCombs (MSFT) 6 Reputation points Microsoft Employee
1 answer One of the answers was accepted by the question author.

Error in Power Query Formula

I have encountered a "Token Literal Expected" error in the second "if" of this formula. The formula is: D4= 0.035, D5= 0.05, D6= 0.07, E4= 1, E5= 0.9, E6= 0.8, Result = if((1-(1-if[#"% CR"]<=D4 then 1 else if…

Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
2,873 questions
asked 2023-10-04T12:08:41.54+00:00
Fady Abdel Massih 0 Reputation points
accepted 2023-10-04T14:53:59.2966667+00:00
Fady Abdel Massih 0 Reputation points
1 answer One of the answers was accepted by the question author.

Outlook macros no longer run until VB editor is opened

I've been running VBA macros in Outlook for years hooked to toolbar buttons. I shut down my computer every night, and I noticed last week that after my morning reboot, none of the macros worked. I discovered that by opening the Visual Basic editor, they…

Outlook
Outlook
A family of Microsoft email and calendar products.
1,847 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
2,873 questions
asked 2023-10-02T13:00:14.4733333+00:00
Jay Burgess 45 Reputation points
accepted 2023-10-04T12:32:18.2933333+00:00
Jay Burgess 45 Reputation points
1 answer One of the answers was accepted by the question author.

Excel VBA - positioning an Userform

Dear All, by the below Excel VBA code I move an Userform below a TextBox: Dim FormTitleSize As Double Dim dblTop As Double Dim dblLeft As Double With Me FormBorderSize = (.Width - .InsideWidth) FormTitleSize = .Height - (.InsideHeight +…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
946 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
2,873 questions
asked 2023-10-03T15:04:14.6866667+00:00
Luca Tramontana 1 Reputation point
commented 2023-10-04T09:30:00.6333333+00:00
Luca Tramontana 1 Reputation point
0 answers

Export excel to csv with a different separator

I want the macro to automatically save a specific workbook sheet in csv format. The macro works but uses " , " as separator. The program that reads the csv file requires the separator to be " ; ". I can't get the macro to replace the…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
946 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
2,873 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,522 questions
asked 2023-10-04T07:40:45.5866667+00:00
Цветан Пантев 0 Reputation points
edited the question 2023-10-04T08:49:59.72+00:00
Jiachen Li-MSFT 19,936 Reputation points Microsoft Vendor
0 answers

Microsoft word - version 2308(Build 16731.20234) - Report generated via .net code showing table including Radiobutton not working and same code is working in 2302(Build 16130.20714). Kindly help ASAP as it's impacting business

Microsoft word - version 2308(Build 16731.20234) - Report generated via .net code showing table including Radiobutton not working and same code is working in 2302(Build 16130.20714). Kindly help ASAP as it's impacting business

Word
Word
A family of Microsoft word processing software products for creating web, email, and print documents.
422 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
2,873 questions
asked 2023-10-03T13:38:39.9466667+00:00
Tiwarri, Rajni 0 Reputation points
edited the question 2023-10-04T07:25:27.73+00:00
AllenXu-MSFT 10,581 Reputation points Microsoft Vendor
1 answer

Is it possible to send emails using VBA from the new Outlook App?

Hi, A number of models I have built in Excel use VBA to automatically send out emails via the Outlook. The code works fine when using the application included with Microsoft 365, however I recently switched to the new (free) Outlook app and the code is…

Outlook
Outlook
A family of Microsoft email and calendar products.
1,847 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
946 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
2,873 questions
asked 2023-10-01T23:14:26.0566667+00:00
Fiona Ellis 0 Reputation points
commented 2023-10-04T06:49:03.25+00:00
SokiGuo-MSFT 16,601 Reputation points Microsoft Vendor
0 answers

Signing VBA project in Word

We have received a new USB stick from QuoVadis to be able to sign for 3 years. The procedure is: 1. open Word, 2. open Visual Basic via developer tools, 3. select the VBA project, 4. open Tools -> Digital Signature, 5. select signature, 6. press OK,…

Word
Word
A family of Microsoft word processing software products for creating web, email, and print documents.
422 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
2,873 questions
asked 2023-10-04T06:42:40.42+00:00
Jacob Daniels 0 Reputation points
1 answer

Microsoft 365 installed but showing Office 2019

hello I installed Microsoft 365, but when I open Microsoft Word, it keeps showing Office 2019. Please, how should I get my apps into Microsoft 365? I already removed the office twice from the control panel and then installed it again, but still…

Microsoft Teams
Microsoft Teams
A Microsoft customizable chat-based workspace.
7,697 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
2,873 questions
Office Management
Office Management
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Management: The act or process of organizing, handling, directing or controlling something.
1,805 questions
Microsoft Teams Development
Microsoft Teams Development
Microsoft Teams: A Microsoft customizable chat-based workspace.Development: The process of researching, productizing, and refining new or existing technologies.
2,395 questions
Microsoft Configuration Manager
asked 2023-10-03T12:39:24.7+00:00
Salah Sa 0 Reputation points
edited a comment 2023-10-04T02:10:27.8466667+00:00
AllenXu-MSFT 10,581 Reputation points Microsoft Vendor
0 answers

How to retrieve cookie from MS-OFBA inside Word Document

Hello I have a question about retrieving the cookie received via MS-OFBA from the Word document itself. Currently in our application, the user selects "Update" on the document they would like to edit, this triggers the document to open locally…

Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
2,873 questions
asked 2023-09-26T16:44:46.1133333+00:00
Connor Shore 0 Reputation points
edited the question 2023-10-03T20:11:20.1566667+00:00
Mike Bowen 1,186 Reputation points Microsoft Employee
10 answers One of the answers was accepted by the question author.

OneNote Sign in issues

Out of nowhere, I am having issues syncing notebooks on OneNote for Windows 10. I see all of my work on OneNote in the browser, but I keep getting an error telling me to sign in. The error reads as: "To sync this notebook, sign in to OneNote."…

Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
2,873 questions
asked 2021-03-16T03:02:06.853+00:00
Folz, Sam 26 Reputation points
answered 2023-10-03T18:22:52.0333333+00:00
LW 0 Reputation points
6 answers

Is there a way to disable the script confirmation popup the appears everytime I click on a button?

I create a simple file and I was trying to automate some processes and I notice that every time I click on the Script button it shows me a popup on the right side that says script run status, its annoying to see that everytime I click on the button. How…

Microsoft Authenticator
Microsoft Authenticator
A Microsoft app for iOS and Android devices that enables authentication with two-factor verification, phone sign-in, and code generation.
4,045 questions
JavaScript API
JavaScript API
An Office service that supports add-ins to interact with objects in Office client applications.
694 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
2,873 questions
asked 2022-02-11T03:49:23.68+00:00
Wilmer Torrez 11 Reputation points
answered 2023-10-03T15:53:38.37+00:00
John LS 0 Reputation points
0 answers

How to download and upload xlsx

I need to upload a xlsx file to sharepoint but the file isn't in my machine, has the possibility to upload the file in base64? If this possibility is true, can you send me the curl of this request? I'm trying but when i saw the file in sharepoint i…

Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
2,873 questions
asked 2023-09-29T15:26:04.98+00:00
Leonardo Ribeiro Bet 0 Reputation points
edited the question 2023-10-03T12:33:56.2966667+00:00
Antonio 260 Reputation points Microsoft Vendor
1 answer One of the answers was accepted by the question author.

Custom Add-in not working in new Outlook

Hi, I have a custom add-in for Outlook that works fine in current version of Outlook Desktop and web, however if I switch Outlook Desktop to "new" it doesn't load anymore. Add-in Error Something went wrong and we couldn't start this add-in.…

Outlook
Outlook
A family of Microsoft email and calendar products.
1,847 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
2,873 questions
asked 2023-09-29T10:45:10.5933333+00:00
Goran Stjepanovic 20 Reputation points
accepted 2023-10-03T11:44:24.3766667+00:00
Goran Stjepanovic 20 Reputation points
2 answers One of the answers was accepted by the question author.

Roomfinder website

Hello, i am tasked with making a website where my business can display every meeting room to see if they are available or not, is there a API i can use to collect data and then display it on the website? also how can i make it so everyone in my business…

Outlook
Outlook
A family of Microsoft email and calendar products.
1,847 questions
Microsoft Graph
Microsoft Graph
A Microsoft programmability model that exposes REST APIs and client libraries to access data on Microsoft 365 services.
2,121 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
2,873 questions
asked 2023-10-02T11:13:21.4733333+00:00
Morten Pettersen Ollestad 20 Reputation points
commented 2023-10-03T09:09:58.8666667+00:00
SokiGuo-MSFT 16,601 Reputation points Microsoft Vendor
1 answer

How to recover a developer account with 2FA activated on it

I need help recovering a developer account with 2-factor security activated on it.

Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
2,873 questions
asked 2023-10-03T07:15:35.0966667+00:00
Harrison Setsofia 0 Reputation points
answered 2023-10-03T07:27:05.8733333+00:00
KETATA Rami 141 Reputation points
1 answer

Keyboard arrow-keys move cursor in opposite direction in protected Right-to-Left Excel Worksheet

Hello, I have a perfectly functional Right-To-Left Excel Worksheet. When the sheet is unprotected, the cursor moves in the direction of the arrow-keys, as expected. But, once I protect the sheet, (some cells are locked, others unlocked) the cursor starts…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
946 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
2,873 questions
asked 2023-09-29T17:16:52.5366667+00:00
Gilad Solomon 0 Reputation points
answered 2023-10-03T05:35:00.8666667+00:00
Tanay Prasad 1,920 Reputation points