Software

Ask something
Discussion Locked

Why won't my settings save?

0 helpful
6 replies

by estreetjerseygirl

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I recently installed Office 2000 on my computer at work, which is running Windows 98. For some reason, none of my settings get saved on Excel 2000. For example, on AutoSave, I set it to save every 2 minutes, save all open workbooks, and do not prompt before saving. I've tried hitting save on the document after I click OK, but even that doesn't save it. Whenever I close Excel and reopen it, it's back to the default of 10 minutes, save current worksheet, and prompt before saving. I want my default font to be Tacoma; whenever I close and reopen Excel, it reverts back to Arial. I have Office 2000 on my computer at home, which has Windows ME, and my brothers' computer has Office 2000 and Windows 98, and they both save the settings withoutany problems. Any help is greatly appreciated!

6 replies

by lizzy

Hi, I got these from the excel help files in excel xp, but it looks like it will work in 2k (i did some editing):

the first way:
Save styles to use in new workbooks
Open a new blank workbook.
Make all changes that you want to keep in your template.
In the blank workbook, click Save As on the File menu.
In the File name box, type book.
In the Save as type list, click Template (*.xlt).
In the Save in list, click the Templates folder.
Click Save.
Note The styles you save will be available in all new workbooks that you subsequently create by clicking New.

by lizzy

2nd way:
Create a template
Decide which type of template you want:

WORKBOOK TEMPLATE
Create a workbook that contains the sheets, default text (such as page headers and column and row labels), formulas, macros, styles, and other formatting youwant in new workbooks based on the template.

WORKSHEET TEMPLATE
Create a workbook that contains one worksheet. On the worksheet, include the formatting, styles, text, and other information you want to appear on all new sheets of the same type.
To display a picture of the first page of a template in the Preview box of the Templates dialog box (General Templates..., New Workbook task pane), click Properties on the File menu, click the Summary tab, and then select the Save preview picture check box.

On the File menu, click Save As.
In the Save as type box, click Template.
In the Save in box, select the folder where you want to store the template.
To create the default workbook template or default worksheet template, select either the XLStart folder or the alternate startup folder. The XLStart folder is usually
C:\Program Files\Microsoft Office\Office10\XLStart
To create a custom workbook or worksheet template, select the Templates folder, which is usually
C:\Documents and Settings\user_name\Application Data\Microsoft\Templates
Enter the name of the template in the File name box. Do one of the following:
Workbook template
Type book to create the default workbook template.
To create a custom workbook template, type any valid file name.
Worksheet template
Type sheet to create a template for default worksheets.
To create a custom sheet template, type any valid file name.
Click Save, and then click Close on the File menu.

by syscokid

On the other hand, if you're on a network at work, there may be system policies in place to prevent you from making those changes.

by estreetjerseygirl

I'm not running W2K; there's no admin login on my computer. No system policies; I have full access. The AutoSave worked just fine when I was using Office 97, but I don't want to go back to 97.

This discussion is closed to new replies.