Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,555 questions
1 answer
matching data issue in if formula
I am trying to compare two columns of data, which are formatted as dd/mm/yyyy to check they match, using a very simple IF formula: =IF(A2=B2,"match","not") Visually those which match are producing a "not" result, even though…
![](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(217.60000000000002, 76%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECB%3C/text%3E%3C/svg%3E)
2 answers
Shortcuts to insert current date and time ( CTRL + ; ) don't work in EXCEL 2021
CTRL + ; to insert current date in a cell CTRL + : to insert current time in a cell both don't work the command does not return anything.
asked 2024-06-02T14:04:32.61+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(60.8, 19%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EOC%3C/text%3E%3C/svg%3E)
Omar Cristian Martinez
0
Reputation points
answered 2024-06-03T06:45:49.42+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
3 answers
Excel file with view permission won't open in desktop app got you don't have permission to open this file
Hi team, We granted a user view permission to an excel file. The user can open the Excel file from the web but encounters a "You don't have permission to open this file" error when trying to open it from the desktop app. Thank you for your help
![](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(60.8, 25%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ3%3C/text%3E%3C/svg%3E)
![](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(102.4, 27%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
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-06-03T01:36:52.6833333+00:00
Jiajing Hua-MFST
6,260
Reputation points Microsoft Vendor
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,555 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,418 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,604 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
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,294 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,555 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,275
Reputation points Microsoft Vendor
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,716
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,555 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,604 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,555 questions
JavaScript API
JavaScript API
An Office service that supports add-ins to interact with objects in Office client applications.
906 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,604 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,920 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,555 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,604 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,369 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,555 questions
OneDrive
OneDrive
A Microsoft file hosting and synchronization service.
882 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,155 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