PDA

View Full Version : Excel 97



30-08-2000, 01:43 PM
The ?spreadsheets how to? section in the August 2000 issue of PC World showed how to display the worksheet name in Excel using the CELL (?filename?) function.
Good tip but the problem is the formula always displays the path name of the last recalculated sheet. Formulae in multiple worksheets or even other workbooks all display the same name.
Does anyone know of a work-around for this apart from using a macro to recalculate each worksheet.