Resetting the standard template.

Mr Nick · May 3rd, 2002, 06:48 AM

I've been messing about with menu customisation and have now found that the standard blank sheet that opens with excel has a modified file menu. I can reset the menus with a reset util I have, but can I reset the standard blank template to inlcude a full menu set so I don't have to keep resetting manually?

Anne Troy · May 3rd, 2002, 07:57 AM

Do you have any files in your XLSTART folder? Files in there can affect the way Excel's defaults.

Have you tried doing a RESET on all your menus/toolbars?

Right-click one of them. Hit Customize. Select each one that is checked (without unchecking it!) and hit the Reset button.

Hope this helps.

Mr Nick · May 3rd, 2002, 08:05 AM

[quote]
Do you have any files in your XLSTART folder? Files in there can affect the way Excel's defaults.

Have you tried doing a RESET on all your menus/toolbars?

quote]

I have no startup templates in my office folders and I have reset all toolbars at least 20 times in the past 2 days.

I have just done it again trying your method and the reset still lasts only as long as Excel is open. When I close and restart, my File menu is missing all print options.

Anne Troy · May 3rd, 2002, 09:53 AM

Home or network?
The only folder I'm concerned about is XLSTART or if you have named an alternate startup for Excel under Tools-Options, General tab. If either of these folders have anything in them, temporarily (at least) remove them (while Excel is closed), and launch Excel again.

Anne Troy · May 3rd, 2002, 09:54 AM

If that does not work, let me know the version.

Mr Nick · May 7th, 2002, 01:00 AM

The only file in there is mscreate, which I have removed with no change to my startup template.

I'm using Excel 97 on a network but all application files are held on my hard disc.

anno · May 7th, 2002, 01:40 AM

mrnick
if no luck with anything else i'd go looking for 'filename.xlt' files.

Mr Nick · May 7th, 2002, 01:45 AM

There are only 3 template files on my system - all of which I have created. None of these templates have revised menus so these are not the root cause. I'm at a loss as to where these changes are coming from!!

Schrödinger’s cat · May 7th, 2002, 02:20 AM

I'd check files on your network - my Word template and i think the Excel one is on a 'personal' network drive so they can be changed remotely.

[ This Message was edited by: Schrödinger’s cat on 2002-05-07 01:23 ]

Mr Nick · May 7th, 2002, 02:26 AM

I'm on a corporate network spanning over 30 branches and in excess of 1500 workstations. If it was a network template, surely this problem would manifest itself on machines other than my own. If I disconnect from the network, the template is still the same.

May 3rd, 2002, 07:57 AM	#2
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	Do you have any files in your XLSTART folder? Files in there can affect the way Excel's defaults. Have you tried doing a RESET on all your menus/toolbars? Right-click one of them. Hit Customize. Select each one that is checked (without unchecking it!) and hit the Reset button. Hope this helps. __________________ ~Anne Troy

May 3rd, 2002, 09:53 AM	#4
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	Home or network? The only folder I'm concerned about is XLSTART or if you have named an alternate startup for Excel under Tools-Options, General tab. If either of these folders have anything in them, temporarily (at least) remove them (while Excel is closed), and launch Excel again. __________________ ~Anne Troy

May 3rd, 2002, 09:54 AM	#5
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	If that does not work, let me know the version. __________________ ~Anne Troy

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 3rd, 2002, 06:48 AM	#1
Mr Nick Board Regular Join Date: Mar 2002 Location: Manchester, UK Posts: 95	I've been messing about with menu customisation and have now found that the standard blank sheet that opens with excel has a modified file menu. I can reset the menus with a reset util I have, but can I reset the standard blank template to inlcude a full menu set so I don't have to keep resetting manually?

May 3rd, 2002, 08:05 AM	#3
Mr Nick Board Regular Join Date: Mar 2002 Location: Manchester, UK Posts: 95	[quote] Do you have any files in your XLSTART folder? Files in there can affect the way Excel's defaults. Have you tried doing a RESET on all your menus/toolbars? quote] I have no startup templates in my office folders and I have reset all toolbars at least 20 times in the past 2 days. I have just done it again trying your method and the reset still lasts only as long as Excel is open. When I close and restart, my File menu is missing all print options.

May 7th, 2002, 01:00 AM	#6
Mr Nick Board Regular Join Date: Mar 2002 Location: Manchester, UK Posts: 95	The only file in there is mscreate, which I have removed with no change to my startup template. I'm using Excel 97 on a network but all application files are held on my hard disc.

May 7th, 2002, 01:40 AM	#7
anno Board Regular Join Date: Feb 2002 Posts: 202	mrnick if no luck with anything else i'd go looking for 'filename.xlt' files.

May 7th, 2002, 01:45 AM	#8
Mr Nick Board Regular Join Date: Mar 2002 Location: Manchester, UK Posts: 95	There are only 3 template files on my system - all of which I have created. None of these templates have revised menus so these are not the root cause. I'm at a loss as to where these changes are coming from!!

May 7th, 2002, 02:20 AM	#9
Schrödinger’s cat New Member Join Date: Apr 2002 Posts: 18	I'd check files on your network - my Word template and i think the Excel one is on a 'personal' network drive so they can be changed remotely. [ This Message was edited by: Schrödinger’s cat on 2002-05-07 01:23 ]

May 7th, 2002, 02:26 AM	#10
Mr Nick Board Regular Join Date: Mar 2002 Location: Manchester, UK Posts: 95	I'm on a corporate network spanning over 30 branches and in excess of 1500 workstations. If it was a network template, surely this problem would manifest itself on machines other than my own. If I disconnect from the network, the template is still the same.