Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,463 questions
0 answers
How to connect aws postgresql with microsoft excel?
Hi, I am using MS Office Home, and I am trying to connect my AWS PostgreSQL DB with my Excel locally as well as on OneDrive, but I couldn't find any option to set up a connection. Can you please help me with this?
asked 2024-04-26T12:33:31.3966667+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, 44%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
Sagar Kumar
0
Reputation points
asked 2024-04-26T12:33:31.3966667+00:00
Sagar Kumar
0
Reputation points
2 answers
One of the answers was accepted by the question author.
MSQuery is has gone from GetData From Other Sources in Microsoft 365 Excel
I have been using MS Query MSQRY32.exe to access data in a 32 bit database using 32 bit DSNs for 30 years. Today I find that MSQuery has been removed from Excel-GetData-From OtherSources. MSQRY32.exe works if I run it directly. It is simply missing from…
asked 2024-03-30T04:11:32.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(185.6, 16%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERL%3C/text%3E%3C/svg%3E)
Roger Lewis
25
Reputation points
commented 2024-04-26T11:55:48.54+00:00
Roger Lewis
25
Reputation points
0 answers
Urgent Help Needed: Why have embedded Excel, PowerPoint, and Word iframes in third-party applications suddenly stopped working and are stuck on the login page?
Hello, I am writing to report a critical issue we are currently facing with Microsoft Office iFrames. Until recently, we have successfully integrated Excel, PowerPoint, and Word iFrames within our applications. However, these iframes are now consistently…
asked 2024-04-26T10:38:09.1+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(176, 76%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMB%3C/text%3E%3C/svg%3E)
Mohamed Berrada
0
Reputation points
edited the question 2024-04-26T10:40:57.0066667+00:00
Mohamed Berrada
0
Reputation points
1 answer
COM timeout Excel
Microsoft 365 Excel version 2403. C# application (WPF on .Net 8) using excel COM interop ("automation") which adds a menu in the Excel application and setsup a click handler (in WPF). All works normally just fine, but when debugging and say…
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,463 questions
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
10,245 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,488 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(240, 30%, 33%)' 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)
1 answer
Share excel as read-only with 1000+ users but they should see the real-time changes in the file
I have a requirement to share an Excel file as read-only with 1000+ users but they should see the real-time changes in the file, the file has macros that update data every second. Want to know the best way to achieve this requirement it could be even…
asked 2024-04-17T08:52:32.8766667+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(9.6, 37%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHA%3C/text%3E%3C/svg%3E)
Hiras, Amit
1
Reputation point
commented 2024-04-26T09:42:25.7233333+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, 17%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYJ%3C/text%3E%3C/svg%3E)
Yanli Jiang - MSFT
21,446
Reputation points Microsoft Vendor
0 answers
Combined charts with ExcelScript
Hi, is it possible to create a combined chart type with ExcelScript ? I didn't find something looking like that in the ExcelScript.ChartType enum page. If not, do you know why or if it's planned to exist in the future? If yes, how ? Thanks
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,463 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,488 questions
asked 2024-04-26T09:27:56.06+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(188.79999999999998, 12%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBC%3C/text%3E%3C/svg%3E)
Broutel, Colin
0
Reputation points
asked 2024-04-26T09:27:56.06+00:00
Broutel, Colin
0
Reputation points
0 answers
How to find course with certificate in Excel
Hey I am using this fantastic site a lot these days to improve my skills and get certificates on it for my LinkedIn profile. I need some certificates on Excel, but cant find a course directed to it. Does anyone have an advice on that? Best regards, Sune
Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,303 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,463 questions
asked 2024-04-26T09:02:44.6666667+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(44.800000000000004, 60%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES0%3C/text%3E%3C/svg%3E)
SuneRoedJeppesen-0182
0
Reputation points
asked 2024-04-26T09:02:44.6666667+00:00
SuneRoedJeppesen-0182
0
Reputation points
2 answers
Does the Task scheduler can open in unattended session (user log off) eMS Office file (like excel)?
Hello, I am trying to automate task which has to open excel file and refresh connections. I tried to use windows task scheduler on remote desktop. Everything is working with option 'Run only when user is logged on". I need to have it working…
asked 2024-04-26T07:05:10.34+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, 55.00000000000001%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERP%3C/text%3E%3C/svg%3E)
Rogaski, Pawel
0
Reputation points
answered 2024-04-26T08:42:25.7866667+00:00
Rogaski, Pawel
0
Reputation points
1 answer
Powershell (?) run a task that open and closes a Sharepoint excel file in the desktop version
I need to open an Excel file from sharepoint in the desktop app daily many times a day, keep it open a couple of minutes and have it close. This so the file updates itself, as it is connected to external data. Can this be acomplished in some way?
asked 2024-04-24T06:37:18.2933333+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, 21%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMR%3C/text%3E%3C/svg%3E)
Mata Ricardo
0
Reputation points
commented 2024-04-26T07:56:43.3866667+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, 82%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELZ%3C/text%3E%3C/svg%3E)
Ling Zhou_MSFT
13,105
Reputation points Microsoft Vendor
0 answers
Using ADF, how to dynamicaly replace excel headers blank spaces with underscores?
Hello, I'm working on an ADF pipeline whose goal is to copy an Excel file to a blob storage as a parquet file. To do so, I'm using a copy data activity. This activity needs to be as parametrized as possible, meaning that the Excel file schema is not to…
asked 2024-04-24T13:33:57.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(310.4, 27%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDM%3C/text%3E%3C/svg%3E)
DIAMANT Marius
0
Reputation points
commented 2024-04-26T07:49:49.2+00:00
DIAMANT Marius
0
Reputation points
0 answers
Full list needed
Hi, I want to get the full list of Cell E31. Please help. https://1drv.ms/x/s!Ai8CrEskdewXzm8D7avpzkgjfPqA?e=8Texgx
Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,303 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,463 questions
asked 2024-04-25T07:01:30.0033333+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, 43%, 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)
Peter_1985
2,506
Reputation points
commented 2024-04-26T01:41:30.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(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
4,675
Reputation points Microsoft Vendor
1 answer
Creating Forms with Dropdown options using Excel
I am creating a request form using Excel. I want to be able to allows users to select one of the options from the drop-down or fill in the necessary information. Can I create a drop down that allows users to select from the list or fill in relevant…
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,463 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,488 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,640 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(9.6, 73%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFB%3C/text%3E%3C/svg%3E)
2 answers
Excel Ribbon does not show PivotTable Analyze option--how do I get it to show?
Per the Youtube video, I want to use PivotTable Analyze to create a dashboard. Here is the Youtube video link: https://www.youtube.com/watch?v=MTlQvyNQ3PM&list=PLRKGHtTCDCzSy7tajGGF_M_Qmo7xdp8Z0&index=25 I want to get the ribbon option for…
![](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(182.40000000000003, 15%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETN%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(265.6, 99%, 35%)' 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.
Macro code problem
Hi, It is having to the line like Worksheets(List1).Cells(RowID2, 8).Value = Format(Now - Worksheets(List0).Cells(RowID, 7).Value, "Standard") Worksheets(List0).Cells(RowID, 7).Value is having the value below. 21/07/2020 6:02:59 PM How to…
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,463 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,488 questions
asked 2024-04-11T04:33:05.8366667+00:00
Peter_1985
2,506
Reputation points
accepted 2024-04-25T08:07:13.1166667+00:00
Peter_1985
2,506
Reputation points
1 answer
Opening an .html file with columnar data in Excel
Hi, I have an .html document that is generated by another application that I would like to import into Excel. I couldn't figure out how to paste .html into this post without having it interpreted, so I have attached it as an image below. I have also…
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,463 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,488 questions
asked 2024-04-23T18:44:36.4233333+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, 9%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPK%3C/text%3E%3C/svg%3E)
Paul Kraemer
266
Reputation points
commented 2024-04-25T08:07:09.18+00:00
Emi Zhang-MSFT
21,856
Reputation points Microsoft Vendor
1 answer
Unable to import excel workbook into MSSQ.
I created a localdb through cmd via a youtube tutorial which allowed me to connect. i am in the mssql application and created my first database. I am wanting to import excel workbooks but the wizard is showing the below error message here, i checked…
asked 2024-04-24T12:44:49.56+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, 19%, 35%)' 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)
Mo
0
Reputation points
answered 2024-04-25T01:34:31.8933333+00:00
ZoeHui-MSFT
32,821
Reputation points
2 answers
One of the answers was accepted by the question author.
file extension not displaying during save as
Hi, When I want to save as a file, the file extension does not display in drop-down menu! for example I mean (*xtds)
Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,303 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,463 questions
0 answers
getSeries() does not work in Excel scripts
Hi, I got an issue with using the getSeries() function in excel script. I want to write script to change the color of the pie chart. I did it manually and I recorded it. The below is the code: function main(workbook: ExcelScript.Workbook) { let…
![](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, 14.000000000000002%, 19%)' 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)
3 answers
How to fix "There was a problem saving and AutoSave was disabled. Please Save As or close and reopen the file."
Hi, so this is the problem we're having: Me and my colleague at work use Excel Spreadsheet (with VBA macro) in Onedrive for our working paper. It works just fine most of the time, but sometime we ran into a problem when saving our progress, it says…
asked 2024-02-01T11:31:38.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(25.6, 89%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPT%3C/text%3E%3C/svg%3E)
Penn Tan
10
Reputation points
answered 2024-04-24T09:53:10.3133333+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, 62%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPL%3C/text%3E%3C/svg%3E)
Philip Leicester
0
Reputation points
2 answers
Power Query cannot list the content of certain SharePoint pages
Hello everyone, I hope someone can give me a tip. We have Office 2021 Professional on the computer and we have SharePoint 2013. There is the function "From File" and then "From SharePoint Folder". So now it's getting funny. Site 1Site…
asked 2024-04-22T16:33:46.62+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, 34%, 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)
Ramaka
0
Reputation points
commented 2024-04-24T08:01:56.18+00:00
Yanli Jiang - MSFT
21,446
Reputation points Microsoft Vendor