[Year 12 IPM] SOS 4 Excel Experts only

[Karl Blake]

You probably copied and pasted from another Excel document into the one providing the alert.  The document you copied from has since been changed, Excel is trying to check the other document and update the data.  The guilty cell will have a reference to the file name of the other Excel file, finding it in a complex spreadsheet is another issue.  If you answer yes then Excel will open the other document if it still resides in its original location with reference to the one that you have open.

Regards, 

Karl Blake
  ----- Original Message ----- 
  From: Damien Joseph Halliday 
  To: List IP&M 
  Sent: Friday, May 20, 2005 8:30 AM
  Subject: [Year 12 IPM] SOS 4 Excel Experts only


  I keep getting the following message and don't quite know how to "deal" with it. Can anyone help?

  "The workbook you opened contains automatic links to information in another workbook. Do you want to update "this workbook with changes made to the other workbook?


  Damien Halliday

  I.T. Coordinator
  Santa Maria College
  50 Separation St.,
  Northcote 3070
  Tel:9489 0485
  This email and any attachments may be confidential. You must not disclose or use the information in this email if you are not the intended recipient. If you have received this email in error, please notify us immediately and delete the email and all copies. The College does not guarantee that this email is virus or error free. The attached files are provided and may only be used on the basis that the user assumes all responsibility for any loss, damage or consequence resulting directly or indirectly from the use of the attached files, whether caused by the negligence of the sender or not. The content and opinions in this email are not necessarily those of the College _______________________________________________ 
  http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe 
  IPM Mailing List kindly supported by 
  http://www.vcaa.vic.edu.au - Victorian Curriculum and Assessment Authority and 
  http://www.vitta.org.au - VITTA Victorian Information Technology Teachers Association Inc

Important - 
This email and any attachments may be confidential. If received in error, please contact us and delete all copies. Before opening or using attachments check them for viruses and defects. Regardless of any loss, damage or consequence, whether caused by the negligence of the sender or not, resulting directly or indirectly from the use of any attached files our liability is limited to resupplying any affected attachments. Any representations or opinions expressed are those of the individual sender, and not necessarily those of the Department of Education & Training.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/ipm/attachments/20050523/db48a859/attachment.html