Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,554 questions
0 answers
Help with Excel
I am trying to configure a spreadsheet to calculate payments to subcontractors. Subcontractors work at several locations each week and we need to know the cost for each of the locations and a total to pay. We also need to be able to filter the data by 2…
asked 2024-05-31T10:32:16.05+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(137.6, 63%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKC%3C/text%3E%3C/svg%3E)
Karen Cushion
0
Reputation points
commented 2024-05-31T16:41:11.1+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(172.8, 53%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
Barry Schwarz
2,271
Reputation points
1 answer
One of the answers was accepted by the question author.
Help with Power Pivot DAX Measures
Good morning. I am in the process of converting a straight up Excel workbook that I inherited to a Data Model within Excel (our client does not use PowerBI, unfortunately). There are a couple of formulas that essentially evaluate the data and calculate…
asked 2024-05-30T15:31:08.9066667+00:00
Darren Anderson
20
Reputation points
accepted 2024-05-31T12:07:17.79+00:00
Darren Anderson
20
Reputation points
3 answers
Console app referencing excel interop RCW
Using VS2022 and Net 8 to make a console app referencing excel interop RCW. On my development machine this interop file is version 16 (MS 365) and works just fine, however on another machine with same OS, same dotnet runtime (runtime shouldn't matter as…
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,554 questions
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
10,417 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.
3,599 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(240, 30%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
1 answer
Pivotting unpivotted data in Power Query
Why can't I have the same number of records after pivotting unpivotted data in Power Query? Am I missing something? Example: Table.Pivot( Table.FromRecords({ [key = "x", attribute = "a", value = "r1"], [key =…
asked 2024-05-30T18:21:31.1866667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(169.60000000000002, 80%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDI%3C/text%3E%3C/svg%3E)
Domenico Ieracitano
0
Reputation points
answered 2024-05-31T06:57:06.0966667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(147.20000000000002, 13%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJH%3C/text%3E%3C/svg%3E)
Jiajing Hua-MFST
6,260
Reputation points Microsoft Vendor
2 answers
Unable to access excel file
I shared a document for my organization one of the user's mail was also sent to the user but he can't access that Excel file.
asked 2024-05-30T06:34:00.23+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(0, 24%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGM%3C/text%3E%3C/svg%3E)
Gokulraj Mani
0
Reputation points
commented 2024-05-31T06:52:59.6733333+00:00
Jiajing Hua-MFST
6,260
Reputation points Microsoft Vendor
0 answers
Need assistance with Approval | Collecting responses and storing
Hello, I am trying to find a solution for my office to (submit request) - (get approval/denial) - (store request and response data). I was attempting to use power automate, but I continue to run into issues getting the flow to function completely. I…
Microsoft Teams
Microsoft Teams
A Microsoft customizable chat-based workspace.
9,292 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,554 questions
asked 2024-05-30T16:11:33.6766667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(121.6, 34%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECN%3C/text%3E%3C/svg%3E)
Cody Nester
0
Reputation points
commented 2024-05-31T02:12:59.3666667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(281.6, 49%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELM%3C/text%3E%3C/svg%3E)
LiweiTian-MSFT
15,195
Reputation points Microsoft Vendor
0 answers
Request for API to Sign Out Users from All Sessions for Non-CAE Applications such as Microsoft365, word, excel, etc.
We need a method to sign out users from all active sessions and applications in Microsoft 365, specifically addressing non-CAE applications. The current RevokeSignInSessions API does not affect non-CAE applications, posing a security risk. Current…
asked 2024-05-30T12:36:40.9366667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(83.2, 7.000000000000001%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAG%3C/text%3E%3C/svg%3E)
Ashutosh Gairola
0
Reputation points
asked 2024-05-30T12:36:40.9366667+00:00
Ashutosh Gairola
0
Reputation points
1 answer
One of the answers was accepted by the question author.
How to highlight errors in Excel
I am trying to format cells within an Excel spreadsheet to highlight errors, but it is not including the cells with "#####". How can I format the spreadsheet to highlight these cells? I currently have a spreadsheet that is populated with…
asked 2024-05-28T21:20:56.7833333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(105.60000000000001, 73%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Alexandra Sansone
20
Reputation points
commented 2024-05-30T06:22:57.0266667+00:00
Jiajing Hua-MFST
6,260
Reputation points Microsoft Vendor
1 answer
Why are the organizational assets library images not showing up in Word or PowerPoint
We have successfully set up Two organization asset libraries as follows: Add-SPOOrgAssetsLibrary -LibraryUrl <url to SharePoint Document Library> -OrgAssetType ImageDocumentLibrary - Thumbnailurl <url to a png file> Add-SPOOrgAssetsLibrary…
asked 2024-05-29T14:32:44.6933333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(25.6, 0%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETB%3C/text%3E%3C/svg%3E)
Todd Bocik
131
Reputation points
answered 2024-05-30T01:38:03.45+00:00
Emi Zhang-MSFT
22,636
Reputation points Microsoft Vendor
0 answers
Any idea why xlfFormulaConvert / Application.ConvertFormula would fail in Excel?
If I try to call xlfFormulaConvert (C-API) with same result in COM Application.ConvertFormula on the following formula, it throws "#VALUE/Error 2015" exception, but if I do convert on each part of the formula, they work. Is it because I need…
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,554 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.
3,599 questions
asked 2024-05-28T19:29:28.36+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(3.2, 71%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETA%3C/text%3E%3C/svg%3E)
Terry Aney
0
Reputation points
commented 2024-05-29T18:50:51.0866667+00:00
Viorel
113.4K
Reputation points
0 answers
HPC com Excel
Ola, estou com dificuldade em executar tarefa entre 3 computadores, sendo que os 3 computadores já estão conectados, 2 no windows serve 2019 e o nó principal está com windows 10, quando Clico em New Job e configuro *test.bat * um teste retirado da…
asked 2024-05-27T15:19:32.95+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(105.60000000000001, 34%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERT%3C/text%3E%3C/svg%3E)
Renato Thomaz
0
Reputation points
commented 2024-05-28T22:51:42.2433333+00:00
Renato Thomaz
0
Reputation points
2 answers
"An operation that uses the database driver could not be completed. If the driver is a Microsoft driver, make sure the driver file isn't damaged, and if it is, reinstall the driver by reinstalling Microsoft Query."
One of the users receive this error. is this issue at our end or at microsofts ?
asked 2023-10-25T20:03:28.8633333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(64, 5%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZA%3C/text%3E%3C/svg%3E)
zubaid ahmed
0
Reputation points
answered 2024-05-28T13:30:39.0233333+00:00
Gabriel Roldan
25
Reputation points
0 answers
Can the Excel Image function accept a "data" url as the source?
Hello, I'm currently developing a Javascript add-in for Excel. During the development process, I have used both the addImage function to include images and the WebImage data type. The current interaction of the code is using the WebImage data type. The…
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,554 questions
JavaScript API
JavaScript API
An Office service that supports add-ins to interact with objects in Office client applications.
909 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.
3,599 questions
asked 2024-05-27T09:20:56.3166667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(0, 4%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJS%3C/text%3E%3C/svg%3E)
Johnny Spicer
0
Reputation points
edited the question 2024-05-28T01:30:27.57+00:00
Jiajing Hua-MFST
6,260
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
Excel Fill schedule
Hi, I use a schedule sheet like the one in the photo. I would like it so when the times are input to the C column, the bars along the schedule are filled in automatically. Like the example in the photo
asked 2024-05-26T09:58:59.6333333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(220.8, 87%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHA%3C/text%3E%3C/svg%3E)
Harrison Allen
20
Reputation points
accepted 2024-05-27T17:37:08.8466667+00:00
Harrison Allen
20
Reputation points
2 answers
FileOpenUserUnauthorized error for excel API
Hi, I hope you are doing well. I am exploring Microsoft Graph Explorer for excel API and testing get worksheets in workbook endpoint. Although I have provided correct drive-item-id , I'm keep getting following error. { "error": { …
Microsoft Graph
Microsoft Graph
A Microsoft programmability model that exposes REST APIs and client libraries to access data on Microsoft 365 services.
10,910 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,554 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.
3,599 questions
asked 2024-03-20T10:15:33.05+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 57.99999999999999%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKP%3C/text%3E%3C/svg%3E)
kishan parmar
0
Reputation points
answered 2024-05-27T09:52:10.9366667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(288, 75%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB%3C/text%3E%3C/svg%3E)
Baris
0
Reputation points
2 answers
One of the answers was accepted by the question author.
how to open local excel file in web browser without upload to cloud storage
After saving the excel file using Python, I want to open it in a web browser.
asked 2024-05-25T06:07:15.26+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(256, 41%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKK%3C/text%3E%3C/svg%3E)
kavin kumar
20
Reputation points
accepted 2024-05-27T09:08:55.39+00:00
kavin kumar
20
Reputation points
1 answer
My TAB BUTTON in Excel doesn't work as usual
Hi all, As usual I press TAB button to move to the next cell on the right (in Microsoft Excel) but recently it moves to the edge of the screen. For example From A1 to B1 is normal but it will move from A1 to U1, or B1, C1, .....T1 to U1 (Column U is in…
asked 2024-05-27T03:06:12.67+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(160, 44%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELU%3C/text%3E%3C/svg%3E)
Lưu Anh Tuấn
0
Reputation points
answered 2024-05-27T07:08:47.4666667+00:00
Jiajing Hua-MFST
6,260
Reputation points Microsoft Vendor
1 answer
Issues connecting Onedrive Excel sheet to third party app
To start off, I want to say that I am in no way a developer or know any coding. So forgive me if I am unable to explain this efficiently. Here is what I am trying to do: I build a very basic app with go.glideapps to show all the vehicles i have. The data…
Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,368 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,554 questions
OneDrive
OneDrive
A Microsoft file hosting and synchronization service.
878 questions
OneDrive Management
OneDrive Management
OneDrive: A Microsoft file hosting and synchronization service.Management: The act or process of organizing, handling, directing or controlling something.
1,154 questions
asked 2024-05-24T17:33:21.12+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(220.8, 28.999999999999996%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETG%3C/text%3E%3C/svg%3E)
Tammy Grange
0
Reputation points
answered 2024-05-27T06:33:34.7033333+00:00
Jiajing Hua-MFST
6,260
Reputation points Microsoft Vendor
2 answers
One of the answers was accepted by the question author.
ボリュームライセンス版のExcelとOffice 365 Apps for enterpriseのExcelの終了処理の違いを知りたいについて
ボリュームライセンス版のExcelとOffice 365 Apps for enterpriseのExcelで Excel.exeの終了処理に違いはあるかご教示いただきたくお願いします。 終了までの時間を比較したところOffice 365 Apps for enterpriseのExcel版がボリュームライセンス版の Excelより約3秒～6秒ほど遅い場合があるためその理由を知りたく質問させていただきました。 宜しくお願いいたします。
Microsoft 365
Microsoft 365
Formerly Office 365, is a line of subscription services offered by Microsoft which adds to and includes the Microsoft Office product line.
3,998 questions
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.
4,880 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,554 questions
asked 2024-05-24T05:10:49.7866667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(169.60000000000002, 1%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETN%3C/text%3E%3C/svg%3E)
Tsuji, Naoaki/辻 直明
20
Reputation points
answered 2024-05-27T04:31:28.22+00:00
Tsuji, Naoaki/辻 直明
20
Reputation points
1 answer
Word Excel in Microsoft 365 subsciption is not working properly
Word Excel tool in Microsoft 365 subscription is not working properly. Can someone help me
Word
Word
A family of Microsoft word processing software products for creating web, email, and print documents.
700 questions
Microsoft Teams
Microsoft Teams
A Microsoft customizable chat-based workspace.
9,292 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,554 questions
asked 2024-05-24T19:15:22.5766667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(246.4, 60%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
juicyyyyy
5
Reputation points
answered 2024-05-24T19:59:55.6366667+00:00
Stefan Blom
2,106
Reputation points MVP