C
C
Cucumbere2018-03-02 16:13:22
Visual Basic
Cucumbere, 2018-03-02 16:13:22

Why is 1 or 2 added to the title when opening an excel file?

There is a certain file, it contains various macros
5a994d8c1dab9728531689.png
When it is opened, an unknown unit is added
5a994de1d9fd7142354763.png
How to cure it?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Anton Kiselyov, 2018-03-02
@Cucumbere

Because the file type is a template.
Therefore, when opening this file, a new file is created based on this template, and therefore a number is added to the name - this is the standard behavior of Excel, Word, etc., when new documents are created based on templates.
Open an empty Excel, open this file from Excel, and resave it in the .xlsm format - in the future, when you open the book in the .xlsm format, the numbers will not be added.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question