Thread: Cell("filename") doesn't update to new filename when do save as.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default Cell("filename") doesn't update to new filename when do save as.
If you done a SaveAs, the formula will update as soon as any calculation
occurs on the worksheet. Otherwise, touch F9.
--
Gary''s Student
gsnu200711

Reply With QuoteReply With Quote