adress in same sheet with sheet.name is not possible

Bülent 1 Reputation point
2021-11-16T09:10:00.277+00:00

I have only one excel-sheet.
If I give in the cell A2
=sheet1!A1
excel optimize these with
=A1

I need these reference. How can I workaround, that excel not optimize automatically?

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.
4,245 questions
0 comments No comments
{count} votes

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.