Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Personal.xls does not open
Hello:
For some reason, when I start Excel, the file personal.xls does not open anymore, not even hidden. I want to be able to save macros to it, but it does not list that as an option anymore. The file that opens is Book1. Personal.xls is in the xlstart directory. Thanks. David |
#2
|
|||
|
|||
It is possible that Excel encountered a problem with the file. Go
to the Help menu, choose About Excel, and click the Disabled Items button. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "C. David Rossen" wrote in message ... Hello: For some reason, when I start Excel, the file personal.xls does not open anymore, not even hidden. I want to be able to save macros to it, but it does not list that as an option anymore. The file that opens is Book1. Personal.xls is in the xlstart directory. Thanks. David |
#3
|
|||
|
|||
xl2002+ have the abililty to quarantine what it thinks are bad workbooks.
They can keep track of them so that it doesn't even try to open them. If you look under Help|About MS Excel, you'll see a button called: "Disabled Items...". Check under there to see if it's marked not to open. You can enable it there, too. If the workbook is really bad, you'll want to put your backup copy in XLStart. "C. David Rossen" wrote: Hello: For some reason, when I start Excel, the file personal.xls does not open anymore, not even hidden. I want to be able to save macros to it, but it does not list that as an option anymore. The file that opens is Book1. Personal.xls is in the xlstart directory. Thanks. David -- Dave Peterson |
#4
|
|||
|
|||
Thanks...that worked.
"Chip Pearson" wrote in message ... It is possible that Excel encountered a problem with the file. Go to the Help menu, choose About Excel, and click the Disabled Items button. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "C. David Rossen" wrote in message ... Hello: For some reason, when I start Excel, the file personal.xls does not open anymore, not even hidden. I want to be able to save macros to it, but it does not list that as an option anymore. The file that opens is Book1. Personal.xls is in the xlstart directory. Thanks. David |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unable to open excel sheet in Protected mode from VB 6.0 | Setting up and Configuration of Excel | |||
Personal.xls and Excel.xlb | Excel Discussion (Misc queries) | |||
Excel Files Won't Open From Shortcut | Excel Discussion (Misc queries) | |||
How do I get my personal macro worksheet to open whenever I open . | Excel Discussion (Misc queries) | |||
Cannot open a file that Excel says is open | Excel Discussion (Misc queries) |