Excel: Links Change After Specifying Alternate Startup Folder

ID: Q89600

The information in this article applies to:

Microsoft Excel for the Macintosh, version 4.0

SUMMARY

Linked spreadsheets that are opened and saved after specifying an Alternate Startup Folder may contain incorrect path information to precedent documents on subsequently reopening the documents. The erroneous link contains path information to the original Microsoft Excel Startup Folder (4).

In this case, the only workaround is to remove the Alternate Startup Folder information and reestablish links for any files which had previously been saved.

Workaround

The following workarounds describe removing the Alternate Startup Folder and reestablishing links to an external document.

To Remove an Existing Alternate Startup Folder

From the File menu, choose Open.

Open the Alternate Startup Folder add-in located in the Macro Library folder.

Press the DELETE key to clear the existing path information for an Alternate Startup Folder and choose the OK button.

When queried to 'Remove current alternate startup folder?' choose the OK button once more.

To Reestablish Links to an External Document

From the File menu, choose Links.

Select the appropriate link and click the Change button.

Navigate to the appropriate folder location and double-click the precedent file.

Microsoft is currently researching this problem and will post more information here as it becomes available.

Reference(s):

"Microsoft Excel User's Guide 1," version 4.0, page 80

"Microsoft Excel User's Guide 2," version 4.0, page 198

Additional query words: 4.00


Keywords          : 
Version           : 
Platform          : 
Issue type        :

Last Reviewed: March 26, 1999