Sheet Names and Auto-calculation

  • Thread starter Thread starter Michael Dobony
  • Start date Start date
M

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.
 
Change formula to reference a cell.........any cell.

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


Gord Dibben MS Excel MVP
 
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.
Click to expand...
Click to expand...

Thanks.
 
Back
Top