Pivot Table Setting Won't Appear
This is Excel 365, the online version. When I create a pivot table the field table pane pops up so I can select what columns I want. When I go to "show settings" for the pivot table they don't show up and then cause the field table pane to also not show up. This happens on all my documents, new and old, multiple devices and web browsers. I've used the pivot table settings on other documents but on Wednesday 11/19/2025 is just stopped working. I didn't change any of my settings. This seems to be a Microsoft glitch but their tech support's only solution to me was to use the desktop version but the point of me using the online version is so that everyone in my Organization can use these shared docs. I'm having a ton of other issues with Microsoft but this one is preventing me from being able to the basic tasks of my job.
Sheet View Issues with Excel Web Browser
Hi, I have created a Excel document for my department to use, I tried Excel App but due to the size of the Spreadsheet it kept freezing, as a result I switched it to use Excel through Web Browser. The sheet no longer freezes which is good. I do have another issue though.....I wanted multiple users to be able to access, edit the sheet at the same time so I did some research and Sheet View seemed to be the way forward. I created a Sheet view for each employee to use so when you go to View, Sheet View and click on the relevant person their work is updated, saved etc and this shouldn't affect others view. This is working in terms of people editing. The main issue now though is that despite following advice sometimes when someone changes a filter on their own sheet view it seems to change others view. My understanding was you can hide, filter etc within your own Sheet view but this doesn't seem to be the case.......PLEASE HELP!!!! My excel and computer Skills aren't excellent to please any simple advise would be great.
Power query refresh using script
I am trying to automate the power query refresh using power automate. Change in a folder triggers multiple scripts. All the scripts seem to be working fine, but the final script to refresh the connections, to show updated query results in the various tabs is not working. function main(workbook: ExcelScript.Workbook) { // Refresh all data connections workbook.refreshAllDataConnections(); } what might be different about this? thanks!Power query refresh using script
I am trying to automate a power query refresh using power automate. The flow seems to be working fine, but the excel in itself isn't refreshing the output tables. The script I am using is this function main(workbook: ExcelScript.Workbook) { // Refresh all data connections workbook.refreshAllDataConnections(); } I can see the updated query in the query editor, but not in the output tabs within the excel.
Weird email "conversion" of a .xlsx attachment
I sent someone an Excel spreadsheet recently as an email attachment, and when he clicked on the attachment to open it, this is what came up on his end. I've never seen anything like this before, but it looks like he doesn't have Excel installed on his computer.
show a due date using data from multiple columns
I have a spreadsheet in excel, such as the Table 1 below. For the 5 Due Date columns, I have conditional formatting set up to format the cells. See Image 1 for a list of rules applied to all Due Date columns. I'd like for another table to populate, showing only columns, Laboratory ID, Description, and any column that is highlighted per the conditional formatting rules. For example, I'd like the return table to look something like Table 2. Table 1. populated in cells G9:N12 ID Description Due Date 1 Due Date 2 Due Date 3 Due Date 4 Due Date 5 Out of Service? 1234 Instrument 1 11/17/2025 N/A 1/31/2027 3/11/2026 11/17/2027 FALSE 1235 Instrument 2 1/14/2026 2/17/2026 3/31/2027 1/23/2026 12/29/2027 TRUE Table 2. Conditional formatting rules applied to cells I9:M12 This Week = White font color, Red fill This Month = Red font color, Light Red fill Next Month = Dark Yellow font color, yellow fill Table 2. If today is 11/10/2025, the table will display columns ID, Description, and only column show for due dates within This Week: ID Description Due Date 1 1234 Instrument 1 11/17/2025
Excel Comments gone/unable to view
I've created a workbook to log information for my work. In this, I had a notes section that I could log all conversations I had when I had contacted a customer so when I hover over the purple indicator in the cell, it would show me the conversations/key notes i've had with customers. I have just opened my workbook today to try and view/add to these comments and all comments now have a red indicator in the cell and the text says the following ' [Threaded Comment] Your version of excel allows you to read this... How can I recover my notes as they are extremely important to my work.Hide Sheet after missusing shortcut Alt+H+W
I was working on an inventory and frequently using the shortcut mentioned above. Unfortunately, during one of those times, I must have misused it, and my sheet became hidden. Since then, I’ve tried multiple methods to unhide it, but none have worked. I would really appreciate your assistance in resolving this issue.
Custom Date format Excel 365 ddd/mm/yy
Hi all, I am working on creating to-do list in Excel 365. I am wanting to display the due date in the following format (ddd - mm - yy) which I know how to do, you go into custom and write your own date format. My date should read: Mon - 01 Jan - 25 I am using Office 365 excel online, when I go to custom it won't let me write the date format I want in, I can only pick from a pre-defined list. My question is does anyone know how to change it, please, thanks Joel
