Word
A family of Microsoft word processing software products for creating web, email, and print documents.
795 questions
2 answers
Error 53 - how to fix
Brand new Mac mini purchased today - installed Office 365 with my work credentials and met with this on start-up
Word
Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,566 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,788 questions
asked 2024-03-25T07:25:05.7533333+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, 32%, 31%)' 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)
MS
0
Reputation points
commented 2024-08-16T08:23:31.8166667+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, 73%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
St Mary NYC
0
Reputation points
1 answer
Excel list of users in AD Groups
I have a list of user names in an excel file, I want to write a powershell script to tell if each user is in a group that contains a string in an AD group. The AD groups are all different names but contain "-String" at the end of the AD group…
asked 2024-08-15T17:04:19.94+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(96, 33%, 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)
Steven
0
Reputation points
answered 2024-08-15T18:50:53.4833333+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, 74%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERM%3C/text%3E%3C/svg%3E)
Rich Matheisen
46,241
Reputation points
4 answers
Getting an error when export a sharepoint list as query in excel
When I tried to export for excel my sharepoint list, and I open the query on excel it shows the follow message as an error:: "There isn't enough memory to complete this action. Try using less data or closing other applications" I tried to…
asked 2024-07-04T16:23:33.9566667+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, 24%, 10%)' 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)
Ma06
0
Reputation points
answered 2024-08-15T14:44:41.64+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' %3ERS%3C/text%3E%3C/svg%3E)
Rodolpho Sousa
0
Reputation points
2 answers
One of the answers was accepted by the question author.
Trying to nest functions
C11 is the average of C2:C7. I then want to round C11 to one digit. The average function rounds to six =(AVERAGE(C2:C7)),ROUND(C11,1) I don't know how to do this. above gives me formula 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(51.2, 16%, 14%)' 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)
1 answer
how can I set up a traffic light system in excel
how can I set up a traffic light system in excel for expired (red), soon to be expired (yellow) and in date alert (green). I want to be able to add a date and it will change colour and automatically change colour when required for the expired and soon to…
asked 2024-08-09T00:00:08.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(313.6, 52%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPC%3C/text%3E%3C/svg%3E)
Paul Callow
0
Reputation points
commented 2024-08-15T05:43:08.73+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
8,770
Reputation points Microsoft Vendor
2 answers
Count different coloured cells in excel
I have a RAG rating spreadsheet containing white (no fill), grey, green, amber and red cells. I am trying to find a formula to count the Red cells in a row. Thanks, Suzanne
asked 2024-08-08T09:36:26.97+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(249.60000000000002, 35%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
Suzanne McCulloch
0
Reputation points
commented 2024-08-15T05:41:25.5233333+00:00
Jiajing Hua-MFST
8,770
Reputation points Microsoft Vendor
1 answer
I can open an Excel 365 file stored on a network drive but it gives an error that "Someone else is working in" it when I try to save.
I can open an Excel 365 file stored on a network drive but when I try to save, it gives an error that "Someone else is working in" it, but there is not anyone else working on it. I also cannot rename the file. There is no .temp file to delete…
asked 2024-08-07T12:20:53.73+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(252.8, 19%, 34%)' 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)
GMartin
0
Reputation points
commented 2024-08-15T05:40:34.9433333+00:00
Jiajing Hua-MFST
8,770
Reputation points Microsoft Vendor
0 answers
how to schedule data refresh script on excel?
I have an excel that connects data to an external source online. i wrote a script to refresh data connections and scheduled the script with power automate online. even though the flow will run and showed that it succeeded but i realised the excel did not…
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,788 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,813 questions
asked 2024-08-14T07:01:05.0433333+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(310.4, 85%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETY%3C/text%3E%3C/svg%3E)
Toh, Yuan Siew
0
Reputation points
edited the question 2024-08-15T01:38:35.8633333+00:00
Jiajing Hua-MFST
8,770
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
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
20
Reputation points
commented 2024-08-14T07:52:13.4033333+00:00
Lưu Anh Tuấn
20
Reputation points
1 answer
How to read excel sheet name Dynamically in SSIS .and use it in excel source.
How to read excel sheet name Dynamically in SSIS .and use it in excel source. Earlier I was using OleDbConnection connection = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + excelFilepath + ";Extended…
asked 2024-08-13T10:19:22.03+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(153.6, 60%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELL%3C/text%3E%3C/svg%3E)
LOUIS Lini (SAFRAN ENGINEERING SERVICES)
0
Reputation points
edited a comment 2024-08-14T04:07:16.5433333+00:00
LOUIS Lini (SAFRAN ENGINEERING SERVICES)
0
Reputation points
1 answer
Losing saves when we are working more accounts on excell
Hello in my organization we got a problem . Each time we work in the same excell spreadsheet with differents Accounts we always risking to lose what a single account do because it don't save well when opened in multiple Accounts. Both if it's in autosave…
asked 2024-08-13T09:11:44.2466667+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, 55.00000000000001%, 26%)' 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)
Simone
0
Reputation points
answered 2024-08-14T02:10:51.2733333+00:00
Emi Zhang-MSFT
24,441
Reputation points Microsoft Vendor
2 answers
On the same computer, after using VBA, the scale of the generated template is smaller. How can I adjust it to match the scale of the original template?
I used a VBA script to copy data from Excel A into the template of Excel B. The VBA script is designed to copy Excel B, save it as a new file called Excel C, and populate it with data from Excel A, creating multiple sheet templates stored in Excel C.…
Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,566 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,788 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,813 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,706 questions
asked 2024-08-13T02:20:23.1466667+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(67.2, 40%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EY%3C/text%3E%3C/svg%3E)
Y
0
Reputation points
answered 2024-08-13T15:55:30.2366667+00:00
John Korchok
5,296
Reputation points
4 answers
One of the answers was accepted by the question author.
Calculate hours from start time and end time
Hi Lets say, that I have work shifts in excel sheet, where Cell A1 = Start time = 11AM Cell B1 = End time = 8PM These cell's are formatted as TIME. Total hours here is 9 hours. Is it possible somehow to check, how many hours there is between From 9AM…
![](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(19.2, 69%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EI%3C/text%3E%3C/svg%3E)
2 answers
Excel macros are getting disabled after uploading file to blob storage.
Hi we have uploaded an excel file to blob storage. this file contains macros written and few cells are formatted as numbers. All these settings gets disabled when file is stored in blob storage. When we try to access the file, we have to again manually…
asked 2024-07-26T04:48:03.7433333+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, 54%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGG%3C/text%3E%3C/svg%3E)
Gupta, Garima
20
Reputation points
answered 2024-08-12T19:40:04.97+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(118.4, 98%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
KarishmaTiwari-MSFT
19,692
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
The transform box around shapes, textbox, images and everything just disappeared in excel
The transform box around shapes, textbox, images and everything just disappeared. I believe this is also called the edit outline box. It is the box where you would have the white circles around the shape that you would drag to resize the shape as well as…
![](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(35.2, 86%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EI%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
Why is the text misaligned on my Excel Chart when I try to print to PDF or save as a photo?
When I create a chart in Excel, it looks great! When I go to save it as an image, or export it to a PDF, the alignment of the text gets messed up. Please help. Here is the image of the chart as it looks like in the worksheet. This is how it is supposed…
asked 2024-08-12T00:17:58.9233333+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, 14.000000000000002%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAV%3C/text%3E%3C/svg%3E)
Adam VanOsdol
20
Reputation points
commented 2024-08-12T12:27:23.2166667+00:00
Adam VanOsdol
20
Reputation points
0 answers
Add Urls in one Colums
I have a significant amount of product information that I plan to upload to my website. I need to aggregate several product URLs into a single cell by title. Considering there are 1000 products, I'm seeking an effective method to do this.
asked 2024-08-10T22:20:01.1466667+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(140.8, 79%, 23%)' 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)
Stuck Joee
0
Reputation points
commented 2024-08-12T02:24:04.3866667+00:00
Emi Zhang-MSFT
24,441
Reputation points Microsoft Vendor
1 answer
excel loses cursor position, and selects another cell
Not all the time, but sometimes when I click on a cell, a different cell is selected. When I click a button, nothing seems to happen. This behavior continues until I switch worksheets, then excel again knows where I clicked. Sometimes I have to exit…
asked 2023-04-21T18:22:48.31+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, 95%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDB%3C/text%3E%3C/svg%3E)
David Berg
20
Reputation points
commented 2024-08-10T21:05:37.9466667+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, 57.00000000000001%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBF%3C/text%3E%3C/svg%3E)
Bill Fazakerly
0
Reputation points
1 answer
How to fix TF400068 error
Have an Excel spreadsheet that is connected to Azure DevOps query to pull data. It was working fine. Now I am getting an error message TF400068. How do I fix this?
Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,566 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,788 questions
asked 2024-08-08T18:26:28.55+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, 47%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELF%3C/text%3E%3C/svg%3E)
Laura Franco
0
Reputation points
answered 2024-08-09T01:48:45.0833333+00:00
Emi Zhang-MSFT
24,441
Reputation points Microsoft Vendor
1 answer
Trying to embed Excel data with links into PowerPoint using the Paste Special and Paste Link features and its not working anymore
Why Its not working when im copying an excel data and pasting it with a link to powerpoint using Paste Special, Paste Link and select MS Excel Worksheet Object ? My powerpoint slides were all link to an excel data and all of it used to work. Now when im…
Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,566 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.
273 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,788 questions
asked 2024-08-08T08:05:10.3433333+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, 87%, 17%)' 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)
Rommel
0
Reputation points
answered 2024-08-09T01:41:01.89+00:00
Emi Zhang-MSFT
24,441
Reputation points Microsoft Vendor