my default new file - office 2000

Qroozn

Well-known Member
Joined
Mar 12, 2002
Messages
543
I am trying to add a macro to my personal.xls but after doing a search noted that i couldnt find the personal.xls anywhere.


How can i determine my default file used for new workbooks on my computer?
 

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().
hey qroozn

have you tried searching for 'personal.xlt' instead of 'personal.xls'?

ps. long time no see. commuting between sydney and brisbane now, i see :wink:. must be racking up those frequent flyer points!
 
Upvote 0
no good.

I found excel.xls in winnt/shellnew and common.xls in C:Program FilesMicrosoft OfficeOfficeLibrary!

Could one of these be it!
 
Upvote 0
i dunno - i think excel.xls might be a demo file for the tutorial?
are you on a network? they may have the default on another drive.
you might want to check the help files too - there is a way to change default settings by creating another template in the xlstart folder. today's cheerful thought - your friendly neighbourhood network administrators may have disabled this facility if the default template is remote though.
cheers
anno
 
Upvote 0
i am now one of the administrators.
Unfortunately for the company I know more on MS office than any one else.

God help them all!
 
Upvote 0

Forum statistics

Threads
1,213,561
Messages
6,114,317
Members
448,564
Latest member
ED38

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top