Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,875 questions
0 answers
Why can't I print anything using Excel online?
When I go to print a document on Excel online I get the message "Something went wrong, and we can't print your workbook." I cannot save the document as a PDF or export it in any way. This has been going on for 2 weeks and has greatly impacted…
![](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(316.8, 95%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETL%3C/text%3E%3C/svg%3E)
1 answer
Unable to access the Worksheet window in Visual Basic editor in Excel (Microsoft 365) on Mac with error message "Variable uses an Automation type not supported in Visual Basic"
Long time Excel user, but new to VBA. Attempted to copy VBA code to sort a worksheet into the VB Editor Worksheet window. VBE would not open the Worksheet widow and produced the error message "Variable uses an Automation type not supported in…
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,875 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,882 questions
asked 2024-09-26T14:59:20.9966667+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(86.4, 67%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBG%3C/text%3E%3C/svg%3E)
Brian Gormley
0
Reputation points
accepted 2024-09-28T18:44:19.32+00:00
Brian Gormley
0
Reputation points
0 answers
Problem in capability control+shift+⬇ with mouse
control+shift+⬇ Previously chosen by pulling the mouse down all the next text There is no such capability now What is the solution?
![](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, 90%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENH%3C/text%3E%3C/svg%3E)
0 answers
Can NOT open the file with VBA
打开excel带宏的文件，打开文件后显示编译错误：无效字符。我的电脑是中文的，文件包含日文，是否是因为这个。
asked 2024-09-28T03:40:38.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(86.4, 35%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYC%3C/text%3E%3C/svg%3E)
YUFENG CUI
0
Reputation points
asked 2024-09-28T03:40:38.1466667+00:00
YUFENG CUI
0
Reputation points
1 answer
How do I get Sites/SharePoint to show on Word/Excel?
In Word/Excel, I want to be able to see SharePoint as a place under OneDrive. Others have this option, but I'm not sure why I don't. This is what I see. And this is what I am trying to see. I have uninstalled and reinstalled office, which did not fix…
asked 2024-09-27T20:02:55.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(35.2, 0%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECM%3C/text%3E%3C/svg%3E)
Cody McCaskill
0
Reputation points
commented 2024-09-27T21:38:57.4966667+00:00
Cody McCaskill
0
Reputation points
0 answers
Removing boxes from Microsoft Documents
Hi all, I recently had my Mac fixed following water damage. I have had to redownload my apps such as Word and Excel which I use very often for university. When I try to use both now I am having multiple issues: In Word a blue box comes up often on my…
![](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, 42%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEJ%3C/text%3E%3C/svg%3E)
2 answers
Grant File access AcrobatUtils.scpt on Mac OS
I recently updated MS Office and Mac OS. When I attempt to open any Word document into MS Word, I am greeted with a Grant File Access permission request, which I cannot cancel out. The only way to dismiss this popup is to force quit MS Word. Why is MS…
Word
Word
A family of Microsoft word processing software products for creating web, email, and print documents.
834 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,875 questions
Office Mac
Office Mac
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Mac: A family of Apple personal computers that run the macOS operating system.
499 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(108.80000000000001, 48%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EF%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(121.6, 31%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC%3C/text%3E%3C/svg%3E)
1 answer
Excel - Automatic date changer
Hi I'm trying to have one date that changes once that date is reached, adding 4 weeks to it. example: starting with the cell displaying 18 Oct 24 when it actually gets to that date, the cell adding 4 weeks to it, displaying 15 Nov 24 this action…
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,875 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,882 questions
asked 2024-09-26T09:57:18.4766667+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(144, 84%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKG%3C/text%3E%3C/svg%3E)
Kieran Grant
0
Reputation points
answered 2024-09-27T19:13:03.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, 53%, 26%)' 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)
Barry Schwarz
2,826
Reputation points
1 answer
One of the answers was accepted by the question author.
How do a break apart a persons name listed in one column, i.e. - John Smith, into two columns, i.e- column A-John, column B-Smith?
I need to sort data in an excel spreadsheet by last name but currently all the data in the column is listed as first name, last name. Is there a way I can break this data apart into two new columns, first name and last name?
asked 2024-09-27T13:32:27.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(102.4, 39%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERH%3C/text%3E%3C/svg%3E)
Robin Hirschfield
20
Reputation points
edited an answer 2024-09-27T18:55:35.08+00:00
Viorel
117K
Reputation points
1 answer
Issue with using special paste to paste links from Excel to Word
Hello! At the firm I work at, we're experiencing an issue while using the "special paste" function to paste links from an Excel table into Microsoft Word. The column width is being extended for some users while others don't experience this…
asked 2024-09-25T20:24:54.1133333+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(70.4, 79%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBJ%3C/text%3E%3C/svg%3E)
Brandon Jackson
0
Reputation points
commented 2024-09-27T18:23:01.4466667+00:00
Brandon Jackson
0
Reputation points
1 answer
Reading log details from text file
Hi, I have a application log files in text format and want to read start/end time of a particular job from text file and then put it into an excel file with VB Script. Let me know if any further clarification or info. is required. Thanks
asked 2024-09-27T12:27:20.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(236.8, 59%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPP%3C/text%3E%3C/svg%3E)
PATEL Prashant Kumar
20
Reputation points
answered 2024-09-27T17:25:26.2333333+00:00
MotoX80
33,471
Reputation points
5 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-09-27T13:21:24.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(108.80000000000001, 28.000000000000004%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Sebastian Sikora
0
Reputation points
2 answers
I can't get Excel SUMIF() function to recognize the asterisk wildcard.
Trying to separate sum by year. Standard mm/dd/yyyy date format was used but there are a half dozen blank cells between dates. =SUMIF($B$9:$B$600,"*2022",$E$9:$E$600) Results are 0 though there are 2 dozen entries for 2022.
asked 2024-09-21T22:53:08.4333333+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, 87%, 18%)' 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)
Robert Spears
0
Reputation points
commented 2024-09-27T09:30:02.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(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
9,760
Reputation points Microsoft Vendor
3 answers
Microsoft Activation Problem
Hello, I have a problem with my Microsoft 365, mainly Word, Excel and PowerPoint, since these are the apps I mainly use. I recently went onto Word to write an application however a message popped up saying 'activate Microsoft 365 to create and edit.'…
asked 2024-09-23T18:47:28.1766667+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, 62%, 17%)' 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)
Joe A
0
Reputation points
edited an answer 2024-09-27T08:50:41.7966667+00:00
Stefan Blom
2,266
Reputation points MVP
2 answers
Excel is showing below error. Quick and Online repair gives error, please find the snapshot
Screenshot 2024-09-26 175640.png
asked 2024-09-26T12:45:31.16+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, 46%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVJ%3C/text%3E%3C/svg%3E)
Vidhi Jaiswal
5
Reputation points
edited an answer 2024-09-27T06:57:38.83+00:00
Jiajing Hua-MFST
9,760
Reputation points Microsoft Vendor
3 answers
Office URI : To open a workbook with Chinese filename
We're going to use "Office URI" to open a local office file (excel, word, ppt, etc) on webpage. By clicking hyperlink, to open the files with local applications, not download them. Office URI is…
Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,619 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,875 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,882 questions
asked 2023-08-17T02:12:06.5666667+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, 74%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EXT%3C/text%3E%3C/svg%3E)
谢天泽/Xie Tianze(Tiny)
5
Reputation points
commented 2024-09-27T06:41:57.8266667+00:00
谢天泽/Xie Tianze(Tiny)
5
Reputation points
1 answer
Excel is showing below error.Also, Microsoft Office365 Marketing email keeps on popping up on right side.
Screenshot 2024-09-26 182800.png
asked 2024-09-26T13:00:14.7866667+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(115.19999999999999, 27%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVJ%3C/text%3E%3C/svg%3E)
vidhi jaiswal
0
Reputation points
answered 2024-09-27T06:25:02.04+00:00
Emi Zhang-MSFT
24,756
Reputation points Microsoft Vendor
12 answers
Workbook.refreshAllDataConnections() is not supported in Power Automate.
Dear all, I have an excel sheet with an active connection which I am able to refresh to get the newest data. Now I've got another PowerAutomate Flow which is working fine with a script inside this Sheet to send me via Teams numbers which I want to be…
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,875 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,882 questions
asked 2023-04-20T06:58:58.2433333+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, 22%, 29%)' 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)
MMPB
70
Reputation points
commented 2024-09-26T21:14:11.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(124.80000000000001, 26%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAA%3C/text%3E%3C/svg%3E)
Alexis Arteta
0
Reputation points
1 answer
INDIRECT function with inline array as parameter?
Is it possible to use the INDIRECT function with an inline array as parameter? ={2\3\5} results in an array with 1 row and 3 columns and values 2 3 5. Assume now you have value 2 in cell A1, value 3 in cell B2 and value 5 in cell C3. Then I expect that…
Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,619 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,875 questions
asked 2024-09-25T13:51:21.5766667+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(300.8, 83%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERH%3C/text%3E%3C/svg%3E)
Regina Henschel
201
Reputation points
commented 2024-09-26T17:49:35.3366667+00:00
Regina Henschel
201
Reputation points
1 answer
One of the answers was accepted by the question author.
Microsoft Word Mail Merge Issue
I am trying to create a mail merge document using an existing list of information from Excel. When completeing the merge Word is converting dates into numerals despite having them formatted as dates in the Excel document. See images below for clarity I…
asked 2024-09-25T17:10:46.4866667+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(278.4, 39%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEN%3C/text%3E%3C/svg%3E)
Elia, Nicholas (HEALTH)
20
Reputation points
commented 2024-09-26T13:29:39.41+00:00
Elia, Nicholas (HEALTH)
20
Reputation points