Thread: question on links where info is added and cell location is wrong
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.links
Bill Manville Bill Manville is offline
external usenet poster
  
Posts: 473
Default question on links where info is added and cell location is wrong
Why not name the cell containing the total (Insert Name Define)
And reference the name in the link formula

= [Red.xls]!Total

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

Reply With QuoteReply With Quote