Share via

Excel Crash When Defining Names

Jinghan 1 Reputation point
2021-09-28T07:36:48.91+00:00

Formulas > Define Name to create a worksheet specific named range caused Excel crash without any error message. The issue happened every time for a specific spreadsheet. But for other excels, it seems fine.

Macros that call .Names Add Name:=… fail as well

I used to copy all raw data to a new blank spreadsheet, and re-built all VBA scripts in the new one. The Add Name worked fine for a moment, but some time later, the crash started again and cannot be recovered.

I am using Windows 10 version 1909, Excel for Microsoft 365 MSO (16.0.13801.20840) 64-bit

Any ideas that I can prevent this issue?
Thanks!

Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,914 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Iskren Gornishkey 0 Reputation points
    2023-05-01T06:53:31.9+00:00

    I figured out that the 64-bit excel messes the names up, whereas the 32-bit is fine.

    To me it is an excel bug, try with the 32-bit version.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.