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 ...
Hello,
The selection order is what causes this difference in behavior.
If you select cell C35 of the current sheet and then cell C35 of sheet 2, you get:
=C35+sheet2!C35.
If you first select cell C35 of sheet 2 and then cell C35 of the current sheet, you get:
=sheet2!C35+sheet1!C35.
It's the sheet switching that causes this.
For your information: the presence of the name (sheet1) in the reference (sheet1!C35) poses a problem when sorting values.