View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default keep getting a "REF" when i reopen a excel file that has formulas

Check to see if you have a link to a cell in another workbook that has been
deleted


--


Regards,


Peo Sjoblom


"munnybunni" wrote in message
...
i am very very new to excel and i have created a report that has some
formulas in it..everything looks good. so i print it.

when i reopen the report a box comes up and has three little square that
say
Update....Dont Update...Cancel....doesnt matter if i pick dont update or
update....in my totals ...upcomes "REF" never did it last year when i
did
this report....

i am not brand spanking new to this excel formula thing and am at a
loss...can someone help me