Sheet Names and Auto-calculation

[Michael Dobony]

I have a workbook with multiple worksheets. Each sheet has a formula for
pulling up the sheet name
=MID(CELL("filename"),(FIND("]",CELL("filename"))+1),50)
It has been working fine until recently when it stopped auto calculating
the formula. Now I suddenly need to hit F9 when I change sheets. Any idea
what happened and how to get it to go back to calculating the name
automatically?

Mike D.

 

[Gord Dibben]

Change formula to reference a cell.........any cell.

=MID(CELL("filename",A1),(FIND("]",CELL("filename",A1))+1),50)


Gord Dibben MS Excel MVP

 

[Michael Dobony]

Change formula to reference a cell.........any cell.

=MID(CELL("filename",A1),(FIND("]",CELL("filename",A1))+1),50)


Gord Dibben MS Excel MVP

I have a workbook with multiple worksheets. Each sheet has a formula for
pulling up the sheet name
=MID(CELL("filename"),(FIND("]",CELL("filename"))+1),50)
It has been working fine until recently when it stopped auto calculating
the formula. Now I suddenly need to hit F9 when I change sheets. Any idea
what happened and how to get it to go back to calculating the name
automatically?

Mike D.

Thanks.