PDA

View Full Version : Personal Workbook in Excel


Jack
02-01-2002, 08:34 AM
Our IS department recently installed a boat-load of software on our machines and inadvertantly blew away my personal workbook in excel. Fortunately I had a back up copy.

My problem is I can't figure out how to have excel open it up hidden every time I go into excel. I use these user-defined functions (bootstrapping the term structure, duration, convexity, etc.) on a regular basis. It a pain to open up the file and hide it by hand every time I need to use these functions.

I couldn't even find any info on the personal workbook feasture in help.

Any help would be appreciated.

Cho Da
02-01-2002, 09:40 AM
Hide it, then exit Excel. When it asks if you want to save changes to personal.xls click yes. You hid it. That's the change.

Also, make sure it is in your XLSTART directory so it opens every time.

<font size=-1>[ This Message was edited by: Cho Da on 2002-02-01 09:41 ]</font>

Jack
02-01-2002, 09:51 AM
Hey that works, thanks.