Using Excel 97, Win 98/2000/XP. We have a number of linked workbooks that reside on a win 2K server. To the best of my knowledge, they seemed to work fine until Monday. Now suddenly, everytime one of the calling workbooks is opened and links updated, we get the File Not Found boxes. I have set the Default Path to the server location (\\dp\dp_c\hhcfiles), but the linking process seems to ignore it. I have also tried setting the Alternete path to the same server location to no avail. The cell formula contains the following: ='C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE\XLSTART\...... and then has the folder and filename where the source data resides. When I do a query of application.startuppath in VBE, I get C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE\XLSTART, however a query of application.altstartuppath returns \\DP\DP_C\HHCFILES, which is what I would expect as that is how I set it. I am baffled.
The default path will not affect where existing links point The alternate startup path will not affect where existing links point, and will have the effect that any files in that directory will be opened automatically when you start Excel - not, I suspect, what you want. Just go into Edit / Links and change the source of the incorrect links back to where it should be. Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup
Hey Bill - Thanks for the heads up on the startup paths and the links point. Certainly some confusion there as I always thought they had some bearing. Plus, I could swear that the way the sheets were set up worked in the past, but I could be wrong. Anyway, went in, changed links sources back to server as they were and all is well. Thanks!
