Forum Discussion
Excel formulas starting to include current sheet name
Hi I recently noticed that formulas in excel starting to automatically include the "current" sheet name after leaving and coming back to the sheet (example below). I don't remember this used to be ...
You're correct – Excel now automatically adds the current sheet name (e.g., Sheet1!) to formulas after you navigate away and back. This is a default behavior change in newer versions.
No setting exists to turn this on or off, so far I know.
Typing formulas manually is the most reliable way to avoid unwanted sheet names. No toggle available – but deleting them takes 1 second.
My answers are voluntary and without guarantee!
Hope this will help you.