Forum Discussion

zeevbngmailcom's avatar
zeevbngmailcom
Copper Contributor
Jan 29, 2023

Excel 2021 error 75

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 c...
Macros and VBA
JKPieterse's avatar
JKPieterse
Silver Contributor
Jan 30, 2023
To allow us to help, do the following:
- When the error happens, take a screen-shot of the error window
- Click the Debug button
- Take a screen-shot of the window that opens. Make sure we can read the entire text on the line that is marked in yellow
- Copy the routine with the yellow marked line and paste that routine (and attach the two screen-shots) in your reply here
  • zeevbngmailcom's avatar
    zeevbngmailcom
    Copper Contributor
    Jan 30, 2023

    JKPieterse 

    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?

    • JKPieterse's avatar
      JKPieterse
      Silver Contributor
      Jan 30, 2023
      If you open the vba editor, what do the sheetnames look like in the project explorer?

Resources