 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / General Excel Questions / March 2008File with VLOOKUPs looking for a phantom file
Hi, I have a workbook with vLookups to 4 other files which work ok. The problem arises when I want to run formatting macros. It runs but then produces the "Update File" explorer box and is looking for a file name which does not exist. The file it is looking for is only one character different from the original file. I have looked at some of the post's and the recommendation to use add-ins is not available to me as I am working on a networked computer which is restricted. Any Ideas greatfully accepted. Davie It sounds like you have a formula that points at a different file--a file that can't be found. Or maybe it's the first time you've tried to update the links. > Hi, I have a workbook with vLookups to 4 other files which work ok. The > problem arises when I want to run formatting macros. It runs but then [quoted text clipped - 11 lines] > > Davie  SignatureDave Peterson Dave, I thought of that and checked the formulae for the rogue link. All seem ok. I had deleted a file but I restored it since reading your post but to no avail. I also had a problem updating the file when it was opening, it was saying other sheets have not been calculated when they were saved. The files are exported from Access. Problem still persists. Davie > It sounds like you have a formula that points at a different file--a file that > can't be found. Or maybe it's the first time you've tried to update the links. [quoted text clipped - 14 lines] > > > > Davie How about: Edit|Links|check status (xl2003 menus) > Dave, I thought of that and checked the formulae for the rogue link. All > seem ok. I had deleted a file but I restored it since reading your post but [quoted text clipped - 28 lines] > > > > Dave Peterson SignatureDave Peterson Alas I am using 2002. I will create a new spreadsheet to allow me to progress. thanks for your suggestions. Davie > How about: > Edit|Links|check status [quoted text clipped - 32 lines] > > > > > > Dave Peterson |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.