PDA

View Full Version : Personal.xlsx worksheet problem


jakester
Apr 25, 2010, 01:47 PM
Hello fellow Excel users -

Here is my problem. I am trying to store my macros to the Personal.xlsx file so that I can use them whenever I want, regardless of the workbook I'm using. I had to create the Personal.xlsx workbook since there wasn't one stored to my computer already, and I stored it to the following path:

C:\Program Files\Microsoft Office\Office12\XLSTART\Personal.xlsx

Now, I hid the Personal.xlsx worksheet so that it would operate in the background and wouldn't appear whenever I opened Excel. However, when I open Excel now, the grid area is blank and no worksheet opens automatically. I have to manually create a new worksheet each time I open Excel which is annoying.

I've never had any problems with hiding the Personal.xls worksheet in Excel 2003 and opening Excel afterward.

Also, one forum I visited suggested running the excel.exe /unregserver in the Start menu and then running excel.exe /regserver and I tried that but it didn't solve the problem.

Any suggestions?

JBeaucaire
Apr 26, 2010, 12:20 AM
Excel 2007 doesn't use .xls or .xlsx for the Personal file, it uses a special file called Personal.xlsb.

Upgrading Personal.xls to Excel 2007 (Microsoft Excel) (http://excelribbon.tips.net/Pages/T006190_Upgrading_Personalxls_to_Excel_2007.html)