You would need an add-in since the workbook is closed

http://xcell05.free.fr/morefunc/english/index.htm


it has a function called INDIRECT.EXT

read help on how to implement it


--


Regards,


Peo Sjoblom


"Mike H." wrote in message
...
I want this formula to auto-update the month name (Tab):

='\\Flrc\shares\Accounting\Hotel Cashier\[Cash ReportWB
CY2007.xls]NOVEMBER
07'!$C$6

How can I do this by just changing the contents of one cell that contains
the word "NOVEMBER" or "DECEMBER"?