Microsoft Graph
A Microsoft programmability model that exposes REST APIs and client libraries to access data on Microsoft 365 services.
10,937 questions
0 answers
Workbook: createSession no longer supported for personal OneDrive accounts.
This API https://learn.microsoft.com/en-us/graph/api/workbook-createsession?view=graph-rest-1.0&tabs=http was working fine for Personal OneDrive accounts but it has stopped today on 6/4/2024. It is returning with the following error. The same error…
![](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(12.8, 53%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
1 answer
Writing a Comparison function for Excel Visual Basic
I'm new to Visual basic and I'm currently trying to write a simple piece of code to Compare value of the cell in 2 different columns. If the values are the same, then I want to fill in cell Green in a third column, used for the comparison result. If the…
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,563 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,608 questions
asked 2024-06-03T17:00:13.3633333+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(76.8, 22%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBN%3C/text%3E%3C/svg%3E)
bill nguyen
0
Reputation points
answered 2024-06-04T16:58:43.8366667+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(179.20000000000002, 48%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ6%3C/text%3E%3C/svg%3E)
jerardocervantes-6575
0
Reputation points
0 answers
Remote Desktop Mobile (RD Client) on iPad not sending shift keyboard combos to Excel
The Microsoft Remote Desktop Mobile app (RD Client) on iPad does not send many keyboard combinations correctly to Excel. I am using an 10th generation iPad with a keyboard to connect to two PCs running Windows 11 Pro to run Excel. Whether I connect to…
asked 2023-10-01T15:27:59.77+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(307.2, 7.000000000000001%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EL2%3C/text%3E%3C/svg%3E)
LanguageGame-2976
20
Reputation points
commented 2024-06-04T16:43:37.69+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(275.2, 27%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZ%3C/text%3E%3C/svg%3E)
Zbark007
0
Reputation points
0 answers
How can I get rid of this annoying "tic-tac" in Excel?
Several of my users are reporting that what looks like a "tic-tac" will show up in their Excel spreadsheets that they cannot close. It looks like a broken dialog box (please see screenshot). Does anyone have a solution for this? The only way…
asked 2024-06-04T15:44:05.3366667+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, 38%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ET%3C/text%3E%3C/svg%3E)
tpoolson_prcsd
0
Reputation points
asked 2024-06-04T15:44:05.3366667+00:00
tpoolson_prcsd
0
Reputation points
0 answers
Create Outlook Subfolder and Rules via Excel Macro
Can one from an Excel macro auto-create Outlook Subfolders and Rules (associated with Subfolder). I know one can create emails via VBA / Macro
asked 2024-06-04T14:09:00.6+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(112.00000000000001, 76%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERW%3C/text%3E%3C/svg%3E)
Rob Walker
0
Reputation points
asked 2024-06-04T14:09:00.6+00:00
Rob Walker
0
Reputation points
1 answer
One of the answers was accepted by the question author.
How to take information from a Form and transfer the data into a word document
I am trying to take answers from a Microsoft Form and transfer them into a Word document. I have done it with Google forms, sheets and docs using the autocrat extension but I need to be able to do this in Microsoft.
asked 2024-06-04T00:09:40.5+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(224.00000000000003, 57.99999999999999%, 31%)' 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)
Amanda Smith
0
Reputation points
commented 2024-06-04T12:41:36.3033333+00:00
Amanda Smith
0
Reputation points
1 answer
Excel 2016 share to mail not working
i, We are having issues with Excel 2016 and sharing it to mail. It gives this error message. Excel is running on an RDS 2016 environment and is not using any Microsoft 365 service. OS and Excel are up2date and I already did an Office repair for it,…
asked 2024-06-03T14:15:07.8933333+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(32, 60%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMB%3C/text%3E%3C/svg%3E)
Max Bongaerts | Arrows ICT Solutions
0
Reputation points
commented 2024-06-04T09:15:27.27+00:00
Max Bongaerts | Arrows ICT Solutions
0
Reputation points
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…
asked 2024-06-03T11:21:46.8933333+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(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)
crib bar
681
Reputation points
commented 2024-06-04T02:35:34.7133333+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,265
Reputation points Microsoft Vendor
0 answers
Creating Excel with EPPlus: Set Column Widths in Pixels and Add Logo
Hello Friends; I have a question for you, I want to pull the data according to id and process it with excell, I even want to add a logo but I couldn't do it somehow, the thing is that I actually want to give the size to the columns and add a logo, but…
ASP.NET Core
ASP.NET Core
A set of technologies in the .NET Framework for building web applications and XML web services.
4,263 questions
ASP.NET
ASP.NET
A set of technologies in the .NET Framework for building web applications and XML web services.
3,335 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,563 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,608 questions
asked 2024-06-03T15:08:17.0233333+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(284.8, 59%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EK%3C/text%3E%3C/svg%3E)
kadir
60
Reputation points
edited the question 2024-06-04T00:57:45.2766667+00:00
Emi Zhang-MSFT
22,716
Reputation points Microsoft Vendor
5 answers
Error when looping through Access queries from Excel - "Too many client tasks"
I have a workbook that has many MS Query connections to an Access database. The workbook has been working great for years, but recently it stopped working after the 64th refresh. First I get a dialogue "Select data source", where MS Access…
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,563 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,608 questions
asked 2023-03-13T17:02:17.0566667+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(240, 42%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESC%3C/text%3E%3C/svg%3E)
Scott Conser
15
Reputation points
answered 2024-06-03T20:47:52.1566667+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(163.2, 33%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EG%3C/text%3E%3C/svg%3E)
Green
0
Reputation points
1 answer
How do I create an excel file for csv export
How do I create an excel file so that it can be converted to a csv file to be exported into quickbooks online
Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,373 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,563 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,663 questions
asked 2024-06-03T19:04:49.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(121.6, 64%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMJ%3C/text%3E%3C/svg%3E)
Mills Judy E
0
Reputation points
answered 2024-06-03T19:09:00.55+00:00
Olaf Helper
41,891
Reputation points
2 answers
One of the answers was accepted by the question author.
MSQuery is has gone from GetData From Other Sources in Microsoft 365 Excel
I have been using MS Query MSQRY32.exe to access data in a 32 bit database using 32 bit DSNs for 30 years. Today I find that MSQuery has been removed from Excel-GetData-From OtherSources. MSQRY32.exe works if I run it directly. It is simply missing from…
asked 2024-03-30T04:11:32.3233333+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(185.6, 16%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERL%3C/text%3E%3C/svg%3E)
Roger Lewis
40
Reputation points
commented 2024-06-03T17:32:12.7233333+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(284.8, 96%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGD%3C/text%3E%3C/svg%3E)
Greg Devine
0
Reputation points
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
Jiajing Hua-MFST
6,265
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,265
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,563 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,430 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,608 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,265
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,265
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,305 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,563 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,280
Reputation points Microsoft Vendor