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 cannot copy a sheet; I get error 75.

Microsoft support does not assist.

Please help

14 Replies

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    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

      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
        If you open the vba editor, what do the sheetnames look like in the project explorer?

Resources