Microsoft Exchange Online
A Microsoft email and calendaring hosted service.
1,647 questions
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(272, 12%, 36%)' 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)
1 answer
One of the answers was accepted by the question author.
Insert Form into an Excel in a Teams Private Channel SharePoint
When I create Excel files and open them in SharePoint, I am able to Insert > Forms > New Form. However, I just created a Private Channel in Teams, opened its SharePoint and created a new Excel file. When I open this Excel file, when I do Insert…
Microsoft Teams
Microsoft Teams
A Microsoft customizable chat-based workspace.
9,629 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,697 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,302 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(307.2, 57.99999999999999%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EV%3C/text%3E%3C/svg%3E)
1 answer
Why does DATEDIF give different results in Excel and SharePoint?
The following formula gives different results in an Excel worksheet and a SharePoint list: =DateDif([Date_1],[Date_2],"md") There are ten cases where Excel gives a higher number than Sharepoint, and two cases where SharePoint gives a higher…
asked 2024-07-02T11:15:45.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(185.6, 43%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
Remster
0
Reputation points
commented 2024-07-22T07:23:57.9533333+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(313.6, 51%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EED%3C/text%3E%3C/svg%3E)
Emily Du-MSFT
44,311
Reputation points Microsoft Vendor
1 answer
Can I retain formula results if background data changes?
To Note I tried like 30 times to post this in the Excel Forums and keep getting some random error. I have a workbook with lets say 4 sheets. A-Coversheet B-Requirements Tracker C-Services D-Software Sheets A, C, and D have rows…
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,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.
3,720 questions
asked 2024-07-11T20:27:21.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(185.6, 87%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJM%3C/text%3E%3C/svg%3E)
Jeanne Meadows
0
Reputation points
commented 2024-07-22T07:08:44.99+00:00
Emi Zhang-MSFT
23,906
Reputation points Microsoft Vendor
2 answers
How can I convert hours in time format to days in decimal format
Hello I run a table in excel to calculate the hours I work for each client. I enter the start and end time in format hh:mm. This calculates the number of hours worked on that project each day into a total which is formatted in the cell as Time. This…
asked 2024-07-18T21:58:01.5233333+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(134.4, 48%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESP%3C/text%3E%3C/svg%3E)
Sonja Porter
0
Reputation points
commented 2024-07-22T07:05:16.9033333+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
7,705
Reputation points Microsoft Vendor
2 answers
Excel online share to other user can edit but can't download
Hi team, My friend using OneDrive Enterprise and he wants to share Excel online files with users that they can edit but can't download. Now "block download" option is missing. he said it appeared when he granted edit access to users. could you…
asked 2024-07-18T12:32:00.8666667+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(230.39999999999998, 60%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECU%3C/text%3E%3C/svg%3E)
Chanwut Upokin
0
Reputation points
commented 2024-07-22T07:04:07.52+00:00
Jiajing Hua-MFST
7,705
Reputation points Microsoft Vendor
1 answer
Excel charts not displayed correctly on different computers
When I opened an Excel document with charts on my Windows 10 computer, the charts displayed normally. However, when I or my colleagues opened the document on another computer or even on my phone, the charts were not displayed correctly. Specifically, the…
asked 2024-07-18T00:38:01.8833333+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, 91%, 20%)' 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)
悦萌 牛
0
Reputation points
commented 2024-07-22T06:59:15.61+00:00
Jiajing Hua-MFST
7,705
Reputation points Microsoft Vendor
1 answer
How to get AutoSave to save to the correct file path rather than a default file location on OneDrive.
AutoSave had been working fine until recently. Now when I open an Excel document, AutoSave is turned off. When I turn on AutoSave, it saves a duplicate to the "default local file location" which is [OneDrive/Documents]. When I change the…
asked 2024-07-16T16:55:21.8+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(89.60000000000001, 80%, 18%)' 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)
Joe Studer
0
Reputation points
commented 2024-07-22T06:37:22.85+00:00
Jiajing Hua-MFST
7,705
Reputation points Microsoft Vendor
2 answers
làm thế nào sửa lỗi 6d066ec1-e2a0-4f36-af93-5d98e6d59ed3 ạ
dạo này mình đăng nhập office 365 bằng tài khoản trường học thì luôn xuất hiện lỗi như vậy. Làm thế nào để khắc phục ạ
asked 2024-07-14T09:29:33.4066667+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(227.2, 12%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENK%3C/text%3E%3C/svg%3E)
Nguyen Khanh Linh
0
Reputation points
commented 2024-07-22T06:23:23.7+00:00
Jiajing Hua-MFST
7,705
Reputation points Microsoft Vendor
1 answer
Pasting & Linking in Word
I am currently trying to paste and link into Word from Excel. I am choosing to keep source formatting, but every time I paste, there are extra spaces in some of the cells with numbers. I have too many tables to paste over to delete all the extra spaces.…
asked 2024-07-12T17:56:49.3766667+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(54.400000000000006, 76%, 15%)' 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)
Kayla
0
Reputation points
commented 2024-07-22T06:20:05.5766667+00:00
Jiajing Hua-MFST
7,705
Reputation points Microsoft Vendor
1 answer
When I create a module in VBA and I'm typing a line of code, it just closes, any solutions?
I'm creating a simple registration system in Excel, I open Visual Basic normally, but when I click on "insert" and then "Module", after 10s Excel closes.
asked 2024-07-04T21:01:09.3766667+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, 94%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENA%3C/text%3E%3C/svg%3E)
Nathanael Andrade
0
Reputation points
edited a comment 2024-07-22T06:14:52.5733333+00:00
Emi Zhang-MSFT
23,906
Reputation points Microsoft Vendor
asked 2024-07-11T07:30:33.8266667+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(233.6, 99%, 32%)' 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)
slardar22
0
Reputation points
commented 2024-07-22T06:11:57.33+00:00
Jiajing Hua-MFST
7,705
Reputation points Microsoft Vendor
3 answers
how to remove auto group window
how to remove this, I don't want this auto group and add another window too many function and lag, too slow when i want to change my work book. if i want another group from a-b to a-c? y create auto group?
asked 2023-04-23T11:53:36.7366667+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(230.39999999999998, 5%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYW%3C/text%3E%3C/svg%3E)
Yongyut Wattanasophon
10
Reputation points
commented 2024-07-20T16:45:41.8566667+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, 25%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMC%3C/text%3E%3C/svg%3E)
Marcus Caselles
0
Reputation points
2 answers
Office Script to delete all rows in a table receives timeout error
I have an office script that is designed to delete all rows in a table. When I run it for 50 or less rows it runs with no problem, but times out when I test it for a larger number of rows (~600). Once this project is live I anticipate the table will…
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,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.
3,720 questions
asked 2024-05-16T14:08:07.1333333+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, 70%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EW%3C/text%3E%3C/svg%3E)
Wewillendure
0
Reputation points
answered 2024-07-19T15:47:59.47+00:00
Wewillendure
0
Reputation points
0 answers
The insertWorksheetsFromBase64() Excel api is missing capability to insert hidden worksheets
Currently we are utilizing insertWorksheetsFromBase64() api for our plugin to insert worksheets into excel workbook. Our team would like to insert HIDDEN worksheets using insertWorksheetsFromBase64() Excel api. Is it feasible from your end to expose…
Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,480 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,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.
3,720 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,689 questions
asked 2024-07-18T20:49:58.24+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, 33%, 39%)' 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)
Tashpulatov, Azizbek
0
Reputation points
edited the question 2024-07-19T01:37:14.3466667+00:00
Emi Zhang-MSFT
23,906
Reputation points Microsoft Vendor
0 answers
How to fix "an operation that uses the driver could noet be compleated. 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." while using Inventory Cube in Escel
Hello, We're trying to troubleshoot the error that is occurring for one of our user's when he tries to run Inventory Cube within Excel. We've already tried reinstalling Office, running Excel in safe mode, changed the settings in order to unblock DDE,…
asked 2024-07-02T12:56:05.92+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(89.60000000000001, 36%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESJ%3C/text%3E%3C/svg%3E)
Suchecki, Jan
0
Reputation points
commented 2024-07-18T13:27:05.3933333+00:00
Suchecki, Jan
0
Reputation points
0 answers
Can i add another value in this PivotFilter statement?
Hi, Can i add another value (e.g. TLOG_MMF_COR_0003) in the below statement 'Type:=xlCaptionDoesNotBeginWith' where existing value1 'ATLOG_MMF_0003' is there already: ============================================ …
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,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.
3,720 questions
asked 2024-07-17T19:28:50.9833333+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(108.80000000000001, 57.99999999999999%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERN%3C/text%3E%3C/svg%3E)
Ruiz Nelli
20
Reputation points
edited the question 2024-07-18T05:27:37.7133333+00:00
Jiajing Hua-MFST
7,705
Reputation points Microsoft Vendor
1 answer
Excel close and reopen - Faulting module name: mso20win32client.dll
Hi, on some computers in my company Excel sometimes closes and reopens without presenting any error messages. Sometimes changes to the file are preserved and sometimes they are lost. Our Excel is part of Microsoft 365 Business standard. These computers…
asked 2024-07-17T08:00:18.2666667+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, 7.000000000000001%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJP%3C/text%3E%3C/svg%3E)
Jean-Philippe Rollandoz
0
Reputation points
answered 2024-07-18T03:59:39.3433333+00:00
Emi Zhang-MSFT
23,906
Reputation points Microsoft Vendor
2 answers
How to fix SSMS import excel issue for Dell/Windows?
Hi, Im starting to learn how to code in SQL and want to start creating my own projects. Im trying to import my own excel file (64 bit) to the SSMS server but am unable to do so because of this image in the attached. Can anyone help with a solution to…
asked 2024-07-17T13:35:41.4566667+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(102.4, 41%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZM%3C/text%3E%3C/svg%3E)
Zach Masessa
0
Reputation points
commented 2024-07-18T01:27:48.94+00:00
LiHongMSFT-4306
25,651
Reputation points
0 answers
Problems with VBA
This will look for current year and month folder problem one is it keeps cresting the 2 folders over and over again, Also would like for it to save the file with the value of a cell like if I put address in it would save in the current month file with…
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,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.
3,720 questions
asked 2024-07-17T09:35:19.11+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(22.400000000000002, 84%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJB%3C/text%3E%3C/svg%3E)
James Barber
0
Reputation points
edited the question 2024-07-18T01:26:55.44+00:00
Jiajing Hua-MFST
7,705
Reputation points Microsoft Vendor