Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,842 questions
1 answer
Macro needed to insert 4 rows in table, copy data from above, copy data from another sheet and paste special (transpose values) to those new rows...repeat till table complete
Hey smart people! I'm a novice at macros and have found myself in a little too deep to handle this task with a macro and don't know VBA language to get this done. I have a spreadsheet with multiple sheets. My macro needs to: Select the main sheet. …
Excel
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,861 questions
asked 2024-09-17T20:10:05.2766667+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(214.4, 83%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECP%3C/text%3E%3C/svg%3E)
Christine Potter
0
Reputation points
commented 2024-09-19T19:33:31.55+00:00
Christine Potter
0
Reputation points
6 answers
Office 2016 professional not responding
When I first start a word or excel, it is not responding and freeze for around 15 seconds. After that, all is good. As my desktop can't access to the internet, it it must be some background progress is trying to connect to the internet and wait for the…
Word
Word
A family of Microsoft word processing software products for creating web, email, and print documents.
822 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,596 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,842 questions
asked 2024-09-18T04:03:35.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(268.8, 81%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPH%3C/text%3E%3C/svg%3E)
Peng He
0
Reputation points
answered 2024-09-19T17:01:26.32+00:00
Stefan Blom
2,261
Reputation points MVP
0 answers
converting date and time as text into a usable date / time format in excel
Want to convert into usable date/time format. Have seen =DATEVALUE(TRIM(MID(SUBSTITUTE(A2,",",REPT(" ",100)),100,100))) used to produce date, but did not include time - I need time code to measure duration between 2 entries
asked 2024-09-19T16:59:12.1733333+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, 68%, 37%)' 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)
Greg Moulton
0
Reputation points
asked 2024-09-19T16:59:12.1733333+00:00
Greg Moulton
0
Reputation points
0 answers
Importar datos - Opción desaparecida de Excel y Outlook - Microsoft Office Profesional Plus 2019
Hasta ahora no me había percatado que en OUTLOOK ha desaparecido la opción de IMPORTAR DE OTROS PROGRAMAS O ARCHIVO, los archivos de ACCESS y en EXCEL ha no está la opción de OBTENER DATOS desde un documento PDF
Outlook
Outlook
A family of Microsoft email and calendar products.
3,724 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,842 questions
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
382 questions
Office Management
Office Management
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Management: The act or process of organizing, handling, directing or controlling something.
2,125 questions
asked 2024-09-19T16:03:58.1433333+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(262.40000000000003, 64%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAF%3C/text%3E%3C/svg%3E)
Angels Ferrer
0
Reputation points
asked 2024-09-19T16:03:58.1433333+00:00
Angels Ferrer
0
Reputation points
4 answers
Files from network locations not appearing anymore in Recent/Pinned
In Excel, I no longer see files I've opened from network locations in the recent files list, and the pinned workbooks from network locations are missing. The drive is still mapped and I can access the files by navigating there. I've tried opening and…
asked 2024-03-20T20:21:29.83+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, 63%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EL%3C/text%3E%3C/svg%3E)
Logan
70
Reputation points
commented 2024-09-19T15:49:31.21+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, 42%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWK%3C/text%3E%3C/svg%3E)
Wagner, Kenneth
0
Reputation points
1 answer
Bug when making an Excel blank document
Hello, i would like to ask how to fix a problem. When i make a new Excel blank document from the Microsoft 365 Office app it opens, but the file doesn't load and doesn't show me a spreadsheet. It gives me a pop-up that Excel could not open the file,…
Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,596 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,842 questions
asked 2024-09-19T12:52:30.2066667+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, 48%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EII%3C/text%3E%3C/svg%3E)
Ivan Ivanov
0
Reputation points
answered 2024-09-19T12:52:30.22+00:00
Q&A Assist
2 answers
Prevent access from excel
I am looking to prevent access from Excel to my SSAS... I have 10 cubes, and several PowerBI that consume from it... But I have some users that connect from excel and I want to prohibit that access. How can I prevent people accessing from excel?
asked 2024-09-18T13:04:27.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(86.4, 71%, 18%)' 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)
mm
0
Reputation points
answered 2024-09-19T09:46:45.8766667+00:00
MikeyQiaoMSFT-0444
2,790
Reputation points
1 answer
i have problem with Excel
Faulting application name: EXCEL.EXE, version: 16.0.10413.20020, time stamp: 0x66ac24f8 Faulting module name: HsAddin.dll, version: 24.100.0.4083, time stamp: 0x65ff039f Exception code: 0xc0000005 Fault offset: 0x0000000000d0ff3f Faulting process id:…
asked 2024-09-03T12:16:40.19+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(128, 53%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJO%3C/text%3E%3C/svg%3E)
Juhmani, Omar (AQJRA)
0
Reputation points
commented 2024-09-19T08:12:54.63+00:00
Emi Zhang-MSFT
24,676
Reputation points Microsoft Vendor
2 answers
Excel: how would I have one cell words make another cell =0
He all, I am wanting to improve my bill payment workbook I made. What I would like happen is that when the cell next to one says "Paid" it will be the next cell changes its value to "0" or become blank. This is so that I can just…
asked 2024-09-03T01:05:03.38+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(262.40000000000003, 86%, 35%)' 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)
Ronindoc
0
Reputation points
commented 2024-09-19T08:11:14.5366667+00:00
Emi Zhang-MSFT
24,676
Reputation points Microsoft Vendor
1 answer
In Excel, after inserting an image, others do not see the image when they open the Excel file.
Using Excel Mondo 2016, the steps are to insert an image by going to Insert > Pictures > Place in Cell. After encountering the issue, an attempt was made to save the file as a 97-2003 Workbook, which results in a compatibility checker prompt for…
asked 2024-09-01T13:27:29.0066667+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(128, 72%, 22%)' 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-09-19T08:09:17.2766667+00:00
Emi Zhang-MSFT
24,676
Reputation points Microsoft Vendor
1 answer
The excel app stays saving but doesn't save the document.
Hi there! I'm having trouble with the Excel app. I create a document and try to save it but the button/sign on the top stays "Saving" and it never appears as "Saved". The only solution but its temporary is to uninstall the app and…
asked 2024-09-10T16:25:51.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(300.8, 53%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECR%3C/text%3E%3C/svg%3E)
Cindy Rocio Elias Lopez
0
Reputation points
commented 2024-09-19T06:45:01.5233333+00:00
Emi Zhang-MSFT
24,676
Reputation points Microsoft Vendor
2 answers
Getting 400 Error Window clicking on "DATA" tab on Excel
I'm a basic Excel user and don't run any Visual Basic App or using Macro or anything when I installed MS, and clicking on "DATA" tab, i get below error window. I've tried: uninstall & reinstall MS (latest version) tried all settings in…
asked 2024-09-11T02:07:56.3+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, 3%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
john_pcc
0
Reputation points
commented 2024-09-19T06:33:53.58+00:00
Emi Zhang-MSFT
24,676
Reputation points Microsoft Vendor
2 answers
Excel printing issue
Strange issue but when I print with the Excel app on a dell laptop, it won't keep the printer settings. I'll select one sided and then it freezes my option to change the landscape, or I'll pick the landscape and the printer reverts back to two sided…
asked 2024-09-12T21:17:51.3833333+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, 4%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENJ%3C/text%3E%3C/svg%3E)
Nick J. Knodel
0
Reputation points
commented 2024-09-19T06:29:46.38+00:00
Emi Zhang-MSFT
24,676
Reputation points Microsoft Vendor
2 answers
Error message - There was a problem getting information from your map chart. Make sure you're online and try again.
Hello, when creating a cartogram, I get an error message - There was a problem getting information from your map chart. Make sure you're online and try again. If it can be solved? It is also not possible to create a map with the default data even if…
asked 2024-09-17T06:34:32.4433333+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(204.8, 3%, 29%)' 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)
scarpuss scarpuss
0
Reputation points
commented 2024-09-19T06:28:19.22+00:00
Emi Zhang-MSFT
24,676
Reputation points Microsoft Vendor
0 answers
Cannot drag DAX to Values in Pivot Table
Hello everyone I have been searching the entire internet for a solution to the problem I am having. I have created a pivot able (data model enabled) and I cannot drag the dax into the values field. This worked like charm up until now. There is no error…
asked 2024-09-18T10:03:06.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(256, 85%, 34%)' 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)
MariaCS
0
Reputation points
commented 2024-09-19T05:17:32.6666667+00:00
Emi Zhang-MSFT
24,676
Reputation points Microsoft Vendor
1 answer
Weird kerning in the formula bar Excel
Excel just started doing this: Expanding the space between the letters when I'm typing in Excel. (Notice the exaggerated space between the "S" and the "L"). When I press Enter, the spacing is corrected, but when I'm editing a cell,…
asked 2024-09-18T13:40:31.17+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(201.6, 13%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPB%3C/text%3E%3C/svg%3E)
Parker Beck
0
Reputation points
answered 2024-09-18T21:08:14.6+00:00
HansV
966
Reputation points MVP
1 answer
One of the answers was accepted by the question author.
Unable to login to Microsoft account, locking me out of critical excel data
Hello, I use OneDrive (business) and sync excel files to the cloud for collaboration. Currently, i am unable to log into my onmicrosoft account (I get a 1001 error message) i need some help, i have lots of data to put in and the job depends on…
asked 2024-01-02T15:23:22.44+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, 57.00000000000001%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECL%3C/text%3E%3C/svg%3E)
Cameron Lewis
20
Reputation points
commented 2024-09-17T15:24: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(307.2, 80%, 39%)' 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)
Barbara F
0
Reputation points
2 answers
One of the answers was accepted by the question author.
Excel processing data is slow
Excel will display multiple threads processing simple data when filtering, and even in cases where the amount of data is not large, there may be a certain amount of time waiting.
Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,596 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,842 questions
asked 2024-09-16T14:15:10.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(204.8, 45%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPR%3C/text%3E%3C/svg%3E)
pu rechard
100
Reputation points
accepted 2024-09-17T14:37:28.2133333+00:00
pu rechard
100
Reputation points
1 answer
How to fix RTD server issue on windows 11 with Microsoft 365
I created an RTD server using pywin32. Initially it did not work. But after i did a clean install of windows 11, it ran for 1 day and subsequently, it was returning #N/A to excel. In excel=>file=>option=>add-in, the ProgId is listed under…
![](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, 30%, 16%)' 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)
0 answers
Referencing Custom Tab created using ExcelDna.AddIn in manifest.xml office js add on
If I've created a custom tab using ExcelDna.AddIn, CustomRibbon.xml, how do I deploy an officejs add on, using manifest.xml, so that officejs addon is placed inside that custom tab created from ExcelDna.AddIn? Essentially this is like combining both…
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,842 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,861 questions
asked 2024-09-17T05:25:28.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(179.20000000000002, 98%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERD%3C/text%3E%3C/svg%3E)
Rahul Deshpande
5
Reputation points
asked 2024-09-17T05:25:28.5766667+00:00
Rahul Deshpande
5
Reputation points