View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
VBA Noob VBA Noob is offline
external usenet poster
 
Posts: 1
Default Name range not updating


Hi all,

I've got a spreadsheet that has a named range and is hidden. Sometimes
it won't auto update unless you click into the cell which contains the
formula

The Auto calc is on so can't understand why it won't update. Happens
with all users of the spreadsheet

Any tips of advise welcome

VBA Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=567849