pivot and groupby function does not work in excel
The pivot and groupby function does not work in Excel, I have a Microsoft 365 E5 license, Excel is updated with version 24.11 build 18227.20222. I ran Microsoft 365 Repair Tool and still have the issue.
What Excel products support Picture in Cell?
I have an Excel application created using Excel 365 and in 2023 (I believe) Microsoft Excel began to support inserting an image in a cell. Whereas prior to that, one could place an image on sheet but the image would remain over the cells. With the…
Cannot Save-As Any Excel File As Of This Morning
I cannot save-as any new Excel files as of this morning (1/21/2025). Attempts to save-as existing Excel files as new files is also not possible. What can I do to remedy this?
Encrypted Excel File Modified in Other Office Software Cannot Be Opened in Microsoft Excel
Hello Everyone, I encrypted an Excel file using Microsoft Excel's built-in password protection. Later, I opened and modified the file in WPS Office(another Office software). After saving the file in WPS, it can no longer be opened in Microsoft Excel.…
How to fix error AADSTS500200: User account is a personal Microsoft account. Personal Microsoft accounts are not supported for this application
Sorry, but we’re having trouble signing you in. AADSTS500200: User account 'su*****sk@gmail.com' is a personal Microsoft account. Personal Microsoft accounts are not supported for this application unless explicitly invited to an organization. Try signing…
Excel 2016 don't open
I am trying to open excel files with external link data without success. It load until 100% but don't open. I did tried this solutions: -Uninstalled Microsoft 365 (Office) -Uninstall Office 2016 / Clean Registry Keys / Reinstall -Apply all Office updates…
I need help with vba coding to properly create an entry form that inputs data to a master table
In microsoft excel, I have a ws titled "ENTRY". On this ws, I have several inputs one of which is "LINE ITEMS" that asks for a quantity between 1-20. Depending on this input, the amount of rows the entry data will be is assigned into…
Files on SharePoint cannot be edited due to the error that shows we temporarily repaired.
Hello Please i need your help on this issue. There is an error message saying WORK BOOK REPAIRED We temporarily repaired this workbook so that you can open it in Reading View on a SharePoint file. The user is trying to Edit Workbook ] Fix it ] Ran…
Files on SharePoint cannot be edited due to the error that shows we temporarily repaired.
Hello Please i need your help on this issue. There is an error message saying WORK BOOK REPAIRED We temporarily repaired this workbook so that you can open it in Reading View on a SharePoint file. The user is trying to Edit Workbook ] Fix it ] Ran…
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
Export scheduling poll results to an excel spreadsheet
I am scheduling a meeting using the scheduling poll for over 15 people and over 30 options. Is there a way to export the results to an excel spreadsheet (similar to the Doodle export function)?
Excel Scripts "Refresh All" function not working for Excel Online
I have recorded a very basic Office script, as below: function main(workbook: ExcelScript.Workbook) { // Refresh all data connections workbook.refreshAllDataConnections(); } It refuses to refresh the Power Query data that is coming from 2 tables…
I keep getting error code 9n155 while sign in for MS365.
Hi, I am facing this issue for few weeks and unable to sign in MS365. I am using Mac 2024 with update software. I get this message while sign in MS 365: Correlation Id: 60442844-a2a7-4143-b80a-5e3001c84f34 Timestamp: 2025-01-22T15:51:52.000Z DPTI:…
How to fix 0x8002802B Excel issue without repair Microsoft 365?
I have develop a tool which is using Microsoft.Office.Interop.Excel.Application and Microsoft.Office.Interop.Excel.Workbook to operate Excel. It can work well, but when my office get update from IT, my tool will get…
How to create Excel file with Visual Studio 2022 and C#
I'm working with Visual Studio 2022, Project WPF C# with .Net 6.0 and Entity Framework Core. DataBase MS SQL Express.I have also a valid and active licence Microsoft Office 365. I try to Create an Excel File but I have different error msg (see…
Single value expected, but array delivered
Hi @ all! This formula should spill all data from January 2025 and expand this array by 3 (3 = WEEKDAY from January 1st, 2025). But it only works if the @ is…
Security Excel
After browsing several forums, I find that the only real security for an Excel file is encryption with a password. Unfortunately, a person who knows the password can change it after having access to the file. Is it possible with VBA to put a password in…
How can I fix 0x8002802B (TYPE_E_ELEMENTNOTFOUND) issue without repair Microsoft 365?
I have develop a tool which is using Microsoft.Office.Interop.Excel.Application and Microsoft.Office.Interop.Excel.Workbook to operate Excel. It can work well, but when my office get update from IT, my tool will get…