Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,619 questions
1 answer
Excel 365 - Heavy File Opening Issue
Hi, I am facing issue with opening 20MB excel file, the file has vlookup formula from other file. The issue I am facing since today morning, the excel file taking too much time around half an hour to open that file. Don't know what update Microsoft…
asked 2024-06-06T09:30:47.1233333+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' %3EAK%3C/text%3E%3C/svg%3E)
Anil Kumar Thakur
5
Reputation points
commented 2024-06-14T01:33:02.9333333+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,825
Reputation points Microsoft Vendor
1 answer
Excel & Powerpoint translation fail
I used to do translation from Excel spreadsheet or Power point from Chinese to English. Several months ago, this function stops working and I get this error message. Any clues?
asked 2024-06-05T03:50:14.63+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, 19%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDW%3C/text%3E%3C/svg%3E)
Dani Widjaja
0
Reputation points
commented 2024-06-14T01:25:27.62+00:00
Jiajing Hua-MFST
6,825
Reputation points Microsoft Vendor
1 answer
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
commented 2024-06-14T01:21:15.3533333+00:00
Jiajing Hua-MFST
6,825
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
Need help with Sync Outlook Calendar into Excel Spreadsheet
I need to figure out a way to Sync an Outlook Calendar into Excel spreadsheet without going back to the spreadsheet each time I add an event on the Calendar. Was watching video's yesterday but the concept of using codes went over my head just a little. …
asked 2024-06-10T14:59:38.0266667+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, 91%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGH%3C/text%3E%3C/svg%3E)
Govea, Hugo
20
Reputation points
commented 2024-06-13T13:05:52.46+00:00
Govea, Hugo
20
Reputation points
0 answers
How to fix keyboard issue in laptop in typing right to left and left to right.
If you're experiencing issues with your laptop keyboard where the typing direction switches between right-to-left (RTL) and left-to-right (LTR), here are some steps you can follow to fix it: Check Keyboard Shortcuts: Sometimes, the typing direction can…
Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,408 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,619 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(44.800000000000004, 8%, 14%)' 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
Enable/Disable Drop Down List according to another value
I need to create a drop down menu, that only appears when a certain value in cell A2 is chosen (from another data validation list), but that it is disabled and blocks the cell (grey out and not possible to type anything) when the value in cell A2 changes…
asked 2024-06-12T12:38:42.3933333+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(16, 67%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
Ale Martinovic
0
Reputation points
commented 2024-06-13T08:04:59.25+00:00
Ale Martinovic
0
Reputation points
1 answer
Why does Excel freeze when copying large ranges and how can I fix it?
When attempting to copy a large range, Excel freezes and gradually consumes all available memory (16 GB) over a ten minute period. This issue occurs even in safe mode and repairing Office 365 has not helped. However, when running Excel as administrator,…
asked 2024-06-11T20:16:26.86+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(38.4, 85%, 13%)' 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)
Roger Novak
0
Reputation points
commented 2024-06-13T08:04:59.1266667+00:00
Jiajing Hua-MFST
6,825
Reputation points Microsoft Vendor
2 answers
One of the answers was accepted by the question author.
Run script on multiple users (using Excel table)
Hello everyone, im trying to build a PowerShell script that runs a command multiple times but with different URLs, but i cant quite understand how to build it. The point is to remove a user from the Share Point sites listed in the column D. So lets say…
![](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, 7.000000000000001%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EE%3C/text%3E%3C/svg%3E)
1 answer
Power query not loading numbers
Hello Every one, I use a query made out of excel files stored in a folder. On a regular basis, I add an excel file in the folder and refresh the query. Since the update of the 30th of May, when I refresh the query, every columns are loaded and added to…
asked 2024-06-12T12:21:00.08+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, 83%, 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)
StokesXD
0
Reputation points
answered 2024-06-13T06:49:50.41+00:00
Jiajing Hua-MFST
6,825
Reputation points Microsoft Vendor
0 answers
How can I force the 'Access Web content' user authentication dialogue box to pop up using VBA?
I have some Power Queries in my Excel file that pull data from other Excel files stored on a SharePoint site. When a new user tries to manually refresh those queries using the "Refresh All" button on the ribbon (Data / Queries &…
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,619 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,657 questions
asked 2024-06-12T13:19:53.15+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, 32%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWJ%3C/text%3E%3C/svg%3E)
White, Jim (J.G.)
0
Reputation points
edited the question 2024-06-13T05:18:32.8566667+00:00
Jiajing Hua-MFST
6,825
Reputation points Microsoft Vendor
0 answers
Erro ao executar um suplemento desenvolvido em VBA
A aplicação em VBA que fiz para automatizar os meus processos rodava até no dia 24 de agosto de 2023, e após esta data passou a aparecer o seguinte erro. Erro em tempo de execução '-2147417848 (80010108)' O objeto chamado foi desconectado de seus…
asked 2023-08-29T14:27:32.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(198.4, 44%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGS%3C/text%3E%3C/svg%3E)
Giovani Santiago Junqueira
10
Reputation points
commented 2024-06-12T17:11:56.58+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(73.60000000000001, 40%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECA%3C/text%3E%3C/svg%3E)
Cledemir Aloisio Gava
0
Reputation points
1 answer
When using Active X controls, a message that the object cannot be inserted appears.
When using Active X controls, a message that the object cannot be inserted appears. not available I would like to ask for your help. Thank you!
asked 2024-06-06T08:20:36.6166667+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, 51%, 25%)' 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)
william
0
Reputation points
commented 2024-06-12T09:23:55.6933333+00:00
Jiajing Hua-MFST
6,825
Reputation points Microsoft Vendor
1 answer
Excel file having links with different excel files opens with long delay
Hi some of our finance users are working on Excel sheet. they have one consolidated file which has link to almost 15 other excel files to fetch the data. it was working fine a couple of day ago but suddenly it is taking more than 20 minutes to open. Need…
asked 2024-06-05T15:07:46.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(268.8, 38%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESA%3C/text%3E%3C/svg%3E)
Sajid Ali Shah
236
Reputation points
commented 2024-06-12T09:05:55.8+00:00
Jiajing Hua-MFST
6,825
Reputation points Microsoft Vendor
2 answers
Migrating Excel Files from On Prem to SharePoint while retaining links
We are currently planning a migration of active files from our on prem servers to SharePoint. We copied over a folder which has Excel workbooks with links to other workbooks. It appears the links do not work when opened from SharePoint. We have hundreds,…
asked 2024-06-07T18:47:11.0633333+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, 14.000000000000002%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
Alex M
0
Reputation points
commented 2024-06-12T07:42:52.27+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
43,256
Reputation points Microsoft Vendor
1 answer
How to include numbers with hyphens in Subtotal function
I am currently using a =SUBTOTAL formula to count a column of date but am having some issues. For example, I have 30 cells in this column that all include various numbers, but they also include numbers with hyphens— ex. 20-22, 106-107 etc. when i run…
asked 2024-06-11T18:33:18.1633333+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, 96%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJA%3C/text%3E%3C/svg%3E)
Jack Allen
0
Reputation points
answered 2024-06-12T02:18:07.56+00:00
Emi Zhang-MSFT
23,116
Reputation points Microsoft Vendor
0 answers
Editing an Excel file without tables using MSGraph API
Hi all, I want to use the MSGraph API in order to edit excel files on Sharepoint. I now see that you need a workbookTable_id in order to use the python function: result = await…
Microsoft Graph
Microsoft Graph
A Microsoft programmability model that exposes REST APIs and client libraries to access data on Microsoft 365 services.
11,123 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,619 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,657 questions
asked 2024-06-11T07:50:01.5933333+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, 83%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDT%3C/text%3E%3C/svg%3E)
Dennis Tran
0
Reputation points
edited the question 2024-06-12T01:34:52.9333333+00:00
Jiajing Hua-MFST
6,825
Reputation points Microsoft Vendor
2 answers
How to convert Office LTSC to "normal" Professional Plus 2021?
Hi all I used this script by farag2 on GitHub to download and install just the Office applications I need (Excel, Word & PowerPoint), but it appears this isn't compatible with my product key, as displayed in the screenshot below: Why is there a…
Word
Word
A family of Microsoft word processing software products for creating web, email, and print documents.
719 questions
Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,408 questions
PowerPoint
PowerPoint
A family of Microsoft presentation graphics products that offer tools for creating presentations and adding graphic effects like multimedia objects and special effects with text.
239 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,619 questions
asked 2024-06-11T10:01:56.0366667+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(80, 21%, 17%)' 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)
Timmy
26
Reputation points
commented 2024-06-12T00:50:48.4933333+00:00
Emi Zhang-MSFT
23,116
Reputation points Microsoft Vendor
1 answer
Blazor for Excel Web Add-in?
Why there is no Blazor option to create Excel Web Add-ins?
Blazor
Blazor
A free and open-source web framework that enables developers to create web apps using C# and HTML being developed by Microsoft.
1,458 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,619 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,657 questions
asked 2024-06-11T17:53:54.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(291.2, 19%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFM%3C/text%3E%3C/svg%3E)
Fernando Magrina Ferreira
0
Reputation points
answered 2024-06-11T18:48:42.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(211.20000000000002, 61%, 30%)' 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)
Bruce (SqlWork.com)
59,471
Reputation points
0 answers
Excel shape resizes when moved
I am having issue with this code below. I am attempting to copy and paste a shape to certain position. When I adjust the .top and .left property of the copied shape the height and width get altered slightly from the original. Why is the shapes height and…
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,619 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,657 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(227.2, 76%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
2 answers
Importing Large Data Sets in Visual Studio 2019 and SQL Server 2019 on Windows 11
Hi everyone, I recently installed Visual Studio 2019 and SQL Server 2019 on my Windows 11 system. When creating a project that involves importing a large data set with more than 1 billion rows, I encounter some issues. When using the SSIS process and…
![](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(300.8, 60%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMK%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(9.6, 79%, 10%)' 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)