[Hints & Tips] Personal Macro Workbook 2007

As usual, here is the solution to a problem I experienced with Office 2007, just in case it could save some time to someone else.


Since I installed Office 2007, when I double-clicked on any XLS file to open it, Excel 2007 opened but did not load the file or took several minutes to load it.


  • Go to the folder containing the Personal Macro Workbook
    (usually C:Documents and Settings<userid>Application DataMicrosoftExcelXLSTART)
  • Open the personal.xls file, go to View and unhide the worksheet.
  • Go to the Office Button, choose Save As and select Excel Binary Workbook.
  • Go back to View and hide the worksheet once again.
  • Click on Save icon in the Quick Access Toolbar and save the file again.
  • Close the Excel window.
  • Remove from folder the old personal.xls file
    (save it elsewhere, for safety)

Now it is possible again to open XLS files by simply double-clicking on them.

Please use Facebook only for brief comments.
For longer comments you should use the text area at the bottom of the page.

Facebook Comments

Leave a Reply

In compliance with the appropriate provisions of the law I state that this site is no profit, has not a predefined recurrence and is not updated according to a deadline. It may therefore not be considered an editorial product under Italian law #62 of March 7th, 2001. In addition, this site makes use of the right of citation for academic and criticism provided in Article 10 of the Berne Convention on copyright.