Invalid external reference message
When I close this workbook I get the message "Your formula contains an
invalid external reference to a worksheet. Verify the path, workbook, and range name or cell reference are correct and try again". The error does not seem to cause a critiacal problem. It gives no indication where the problem is. How do I go about finding the problem formula. Thanks Laurence |
Invalid external reference message
Sometine i found the worksheet menu Edit - Links helpful, but not very often.
Last time I had this type problem I deleted everything in the worksheet and still had tthe error. The worksheet was corrupted. I did a binary search on the .xls file a found the link, but there was no data in the workbook. Good Luck. I simply copied every worksheet to a new workbook one at a time and the error disappeared. "Laurence Lombard" wrote: When I close this workbook I get the message "Your formula contains an invalid external reference to a worksheet. Verify the path, workbook, and range name or cell reference are correct and try again". The error does not seem to cause a critiacal problem. It gives no indication where the problem is. How do I go about finding the problem formula. Thanks Laurence |
Invalid external reference message
Hi Lawrence
Download a copy of Bill Manville's Findlink.xla and use that to show you where the link exists and delete or amend it. You can find the zip file at http://www.bmsltd.ie/MVP/Default.htm -- Regards Roger Govier "Laurence Lombard" wrote in message ... When I close this workbook I get the message "Your formula contains an invalid external reference to a worksheet. Verify the path, workbook, and range name or cell reference are correct and try again". The error does not seem to cause a critiacal problem. It gives no indication where the problem is. How do I go about finding the problem formula. Thanks Laurence |
All times are GMT +1. The time now is 04:53 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com