Error with Excel's Spreadsheet Compare: Cannot open files generated by write.xlsx() in R.
Using Office Professional Plus 2021, Excel's Spreadsheet Compare tool fails to open files when I attempt to compare two xlsx files. An error message below appears: 'Error opening workbook. Specified part does not exist in the package.' This happens…
Understanding 'Sysgen Names' and 'Sysgen Names Error' in Office 2021's Spreadsheet Compare Tool
Hello, My colleagues and I use Office Professional Plus 2021 which comes with an add-in with an app called Spreadsheet Compare that compares two Excel books and shows differences in each cell. Apparently, it has an option that enables to detect…
Upload Failed:Problems Refreshing
Hi there, Im currently using a 2019 version of excel. All my files are saved directly to one drive , however when i open old excel documents using one drive on my desktop (file explorer) , it doesnt just let me save the changes made . instead it…
Optimizing Pivot Tables and Slicers for Dynamic Excel Dashboards
A dynamic dashboard is being created in Excel to analyze sales data, including Date, Region, Product, Sales, and Profit. What are the steps to configure Pivot Tables for automatic refreshing with source data updates, ensure that multiple Pivot Tables…
Numbers spell in excel with three decemals
Hi, can anyone help me with excel to spell number like this ? its for a currency BHD 101.123 = one hundred one Bahraini Dinars And One Hundred and Twenty Three Fils Only. The Fils decimals are three from 1-999
Get live numbers from web into my excel sheet
I need to get live numbers from a web page (example, googlfinace) into my excel sheet, so I can keep my excel sheet updated at all time, fore purpose of quick action point.
Why do these cells in Excel stay green and cannot be changed?
I have a spreadsheet that my team uses in excel that we share on the web browser and use chrome. When we try to insert new cells they show up as white until we enter txt into them, and then they are hgihlighted as this green color shown below. But we…
Excel - how to convert dd-mmm-yyyy to dd/mm/yyyy
My date format is now 01-Oct-2024, how can i use excel formula to change to 01/10/2024 dd/mm/2024
Otra cuenta de tu organización ya inició sesión en este dispositivo. Intentalo de nuevo con otra cuenta.
mi office no me deja ingresar Correlation Id: 76bf7b82-af8c-5640-bd8c-c46d8a8d3b01 Timestamp: 2023-05-08T13:02:52.000Z DPTI: 0eb6fbfed0064a71e4f84f24bf3e853acbd48b6bed4f2bcdab4f7aef376e507e
Multiple Condition Match Look-up [INDEX, MATCH, LEFT, SEARCH]
If after hyphen( -) full match found with A vs B + if left 3 of D match found with A= result need "found" Excel version 2021If after hyphen( -) full match found with A vs B + if left 3 of D match found with A= result need "found"…
Pivot Table doesn't count all data
Everything in the table is mostly correct except the ones with the correct numbers on the right. I kept refreshing the data, but it's still not giving me the correct data and I don't know why. For the count, it's counting every…
Doesn't show the AutoSave button
Hi........! Please answer me, My MS Excel doesn't show the AutoSave icon/ (on and off button) on the top of the left-hand corner. why so that? please give me a solution. My other MS Office products (MS Word, Powerpoint, etc.... are shown it). please sort…
How to calculate the date difference excluding weekend and public holidays for specific date format
I have the following date format , but I can't use these date format to calculate the date difference excluding weekends and holiday. The two date is input as 01-Oct-2024 and 15-Oct-2024. The result should be 9. However, when I use excel function…
Excel's default workbook calculation keeps changing to manual
Got myself a new laptop, after installing Office 365, my Excel's default workbook calculation keeps changing to manual, even though I did not open a file which had manual calculations saved before. Even after I change the settings to be automatic…
Formula problem Excel
Can you please help me? I have a table where columns A and B are combinations of 12 to 19 numbers, and I need to obtain the common number between columns A and B. Any help is appreciated.
Delete multiple members of distribution group using CSV thru Exchange Management Shell On Premise
I received a request from our employees to delete all the members of this particular distribution group within our organization, and upon checking this DL has a total of 7,000 members. Is there any powershell script I can use to delete just the members…
Too much data in PowerQuery can cause Excel to freeze
Import data from an Excel workbook through Power Query, but the data is quite large, with approximately 3000+rows. Importing is normal, but when loaded into Excel, it can cause Excel to freeze. I have created a simple example and this issue will not…
disable Ease of access feedback options
Hello, We use Office 365 version 2006 (build 13001.20384) and we want to disable the ease of access option "Provide feedback with sound" for all out users. This option is default enabled. In Office 365 (version 2002 build 12527.20278) this…
Why can't a program I am writing a script in (AutoHotKey) not getting access to Excel's COMObject feature?
I've been on a chat for hours with Microsoft support and they have passed me on to you here. I have been working with chatGPT, trying to write a script to enable Excel to use a few Auto Hot Keys to run a simple stopwatch function directly in a sheet? …