XL98: Error Saving Personal Macro Workbook

Last reviewed: February 2, 1998
Article ID: Q178518
The information in this article applies to:
  • Microsoft Excel 98 Macintosh Edition

SYPMTOMS

When you quit Microsoft Excel and try to save the Personal Macro Workbook, you receive the following error message:

   Microsoft Excel cannot access the file 'Microsoft Office 98:Microsoft
   Office 98:Office:Startup:Excel'. There are several possible reasons:

   -The file name or path name does not exist.

   -The file you're trying to open is being used by another program.
    Close the document in the other program, and try again.

   -The name of the workbook you're trying to save is the same as the
    name of another document that is read-only. Try saving the workbook
    with a different name.

When you click OK, you receive the following error message:

   You cannot save the Personal Macro Workbook in the startup folder.
   Save it elsewhere now and move it to the starup folder later.

CAUSE

This problem will occur when you do the following:

  • You run Excel directly from the CD or from a share point on a server.

    -and-

  • You create or record a macro in the Personal Macro Workbook and try to save the workbook.

WORKAROUND

To work around this problem, use an alternate startup folder either on your local hard disk or a disk in which you have full (read, write, and change) permissions. Follow these steps to set the "Alternate startup file location" folder:

  1. On the Tools menu, click Preferences.

  2. Click the General tab.

  3. Type the driver name and path in the "Alternate startup file location" box. For example, if you want to set this to your Data folder and your drive is named Macintosh HD you would type the following:

          Macintosh HD:Data
    

STATUS

This is by design in Microsoft Excel 98 Macintosh Edition.

REFERENCES

For more information about the alternate startup file location setting, click the Index tab in Help, type the following text

   alternate

and then double-click the selected text to go to the "Control what happens when you start Microsoft..." topic.


Additional query words: XL98 xlstart altstart network workstation rns
Keywords : xlloadsave
Version : MACINTOSH:98
Platform : MACINTOSH
Issue type : kbprb
Solution Type : kbworkaround


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: February 2, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.