No :~( but I've discovered the root of the problem. I am basing
several lookup formulas on a truncated down version of the
cell("filename") to get the tab name. Is there better way of
referencing the tab with a formula than this?
{=MID(CELL(“filename”),FIND(“]“,CELL(“filename”))+255)}
Though the tabs of course remain static, the cell in the sheet states
the previous tab's name until recalced. Perhaps if I change this
formula, which all the lookups are based upon, a sheet refresh will no
longer be required.


--
MACRE0
------------------------------------------------------------------------
MACRE0's Profile: http://www.excelforum.com/member.php...o&userid=10848
View this thread: http://www.excelforum.com/showthread...hreadid=478527