Jan 29 2023 10:47 AM
I have been using an excel file for a long time, under Office 2016 and Office 2019.
This file contains a VB module.
I have transferred to Office 2021, and now the file does not work correctly: I cannot copy a sheet; I get error 75.
Microsoft support does not assist.
Please help
Jan 30 2023 07:47 AM
Jan 30 2023 09:09 AM
There is no Debug button, as can be seen.
Here is an exact description:
I have an excel file, which has been working correctly for years.
It contains a base sheet that consists of data and simple formulas. In addition, there is a module, that calculates a simple addition of some data from all existing sheets.
Periodically I copy this sheet by pressing the sheet's name with the right mouse button and choosing the Move or Copy... option.
After updating Office to a newer version, when I try to use this option to copy a sheet, I get the above errors. A file named VBxxxx.tmp is created in the original file's folder.
I can, however, copy this sheet manually: open a new sheet with the + command, then copy the content of an existing sheet, and paste it into the new sheet.
It is an annoying bug, one of those added to every new version of Office, usually to stay for eternity. Or isn't it?
Jan 30 2023 11:39 AM
Jan 31 2023 06:38 AM
Jan 31 2023 07:48 AM
OK, looks as if the VBA project of the file is corrupted. You can fix it as follows:
Jan 31 2023 10:47 AM
Jan 31 2023 12:59 PM
Feb 01 2023 06:59 AM
Feb 01 2023 08:30 AM
Feb 02 2023 02:55 AM