I've been trying for 2 hours to get PERSONAL.xls to load for existing workbooks.

Unchecked "ignore other applications" and everything is working fine.

Thanks for the suggestion!

Cindy



Gord Dibben wrote:

Strange.Try one more.................
28-Aug-08

Strange.

Try one more.................uncheck "ignore other applications" in
ToolsOptionsGeneral.

If no joy maybe run a repair from HelpDetect and Repair.


Gord

Previous Posts In This Thread:

On Tuesday, April 22, 2008 4:28 PM
Jim Cone wrote:

Ray,Check for any disabled items from the Help (menu) | About Microsoft Excel .
Ray,
Check for any disabled items from the Help (menu) | About Microsoft Excel ...
"Disabled Items" button.

If that doesn't help, then you could ...
Copy your code out to Notepad.
Delete the Personal.xls file.
Record a macro to create another one.
Paste your code into the new file.
--
Jim Cone
Portland, Oregon USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)




"Ray"
wrote in message
This problem is driving me crazey. Everytime I look for a solution on
the net I don't seem to beable to find one.

I have several macros stored in my personal.xls work book. it is in
the Program Files Microsoft Office office11 xlstart folder.

I was working in that when I opened a workbook the personal would open
hidden and the macros would be available.

a couple of days ago excel locked up and I had to use Task Manager to
kill the process.
Now my personel will not open. To get the macros available I have to
open the personal then open the file i want to work on.

i have checked all the paramaters that I can find. and I still can not
get the thing to open.
I could reload office and it might fix it
there has got to be something that is corrupted that I can find and
fix
can anyone tell me where it is?
Thanks
Ray

On Tuesday, April 22, 2008 6:13 PM
Gord Dibben wrote:

My Personal.
My Personal.xls resides in

C:\Documents and Settings\Gord\Application Data\Microsoft\Excel\XLSTART

That's where Excel creates it if I record a macro to Personal Macro Workbook.

After checking to see if it has been disabled(see Jim's reply) maybe move it to
the above folder.


Gord Dibben MS Excel MVP

On Tue, 22 Apr 2008 13:17:10 -0700 (PDT), Ray wrote:

On Wednesday, April 23, 2008 7:58 AM
Ray wrote:

THE PERSONAL.XLS work book not loading.
This problem is driving me crazey. Everytime I look for a solution on
the net I don't seem to beable to find one.

I have several macros stored in my personal.xls work book. it is in
the Program Files Microsoft Office office11 xlstart folder.

I was working in that when I opened a workbook the personal would open
hidden and the macros would be available.

a couple of days ago excel locked up and I had to use Task Manager to
kill the process.
Now my personel will not open. To get the macros available I have to
open the personal then open the file i want to work on.

i have checked all the paramaters that I can find. and I still can not
get the thing to open.
I could reload office and it might fix it
there has got to be something that is corrupted that I can find and
fix
can anyone tell me where it is?

Thanks
Ray

On Friday, May 02, 2008 4:03 PM
Dreidin wrote:

This strange phenomenon is also happening to me.
This strange phenomenon is also happening to me. Here are some of steps I???ve
taken and their result.
1. Saved my PERSONAL.XLS file (just in case something bad happens)
2. Deleted the PERSONAL.XLS file
3. Recreated it through record a macro ??? The file is correctly in my
applications data\... folder
4. Opening Excel through the START-ALL PROGRAMS-EXCEL2003 the PERSONAL.XLS
file is automatically added in. (This is what I expected)
5. Opening Excel through double-clicking an Excel file no longer
automatically adds in the PERSONAL.XLS file. This used to work yesterday. I
did do a lot of MSACCESS ???to- EXCEL and back transfers, but this shouldn???t
disable Excel from opening the PERSONAL.XLS file through double-clicking.

Any suggestions?

Thanks,
- Pat

P.S. This will be in another question to the forum. I have a simple excel
file that can't import into Excel. I think something is corrupted (time to
reboot & repair and pray)


"Gord Dibben" wrote:

On Friday, May 02, 2008 6:04 PM
Gord Dibben wrote:

Close Excel first and On the Windows Taskbar 1) StartRun "excel.
Close Excel first and On the Windows Taskbar

1) StartRun "excel.exe /unregserver"(no quotes)OK.
2) StartRun "excel.exe /regserver"(no quotes)OK.

See the space between exe and /regserver

You might have to designate a full path to excel.exe.

In that case StartRun "C:\yourpath\excel.exe" /regserver(quotes required)OK.

For the second problem.........how are you trying to "import" the Excel file
into Excel and what happens when you try?


Gord Dibben MS Excel MVP


On Fri, 2 May 2008 13:03:01 -0700, Dreiding
wrote:

On Friday, May 30, 2008 5:59 AM
Ray wrote:

THE PERSONAL.XLS work book not loading.
On Apr 22, 4:28=A0pm, "Jim Cone" wrote:
....
Jim - This is what i did. There is something that seems to get messed
up in the file and breaks the process that opens it. I have several
users that i help on this and I had to do the same on all there
systems. I wish someone would come up with a fix for the problem.

also there are two different paths and the file could be in either one
of them

C:\Documents and Settings\Gord\Application Data\Microsoft\Excel
\XLSTART
C:\Program Files\Microsoft Office\office11\xlstart

I had Personal.xls in both of them and that did not work
I went into EXCEL set up and put the path in the place where is says
open files in this folder. It is usually blank so I filled in the path
and it still did not work
so then I did what Jim suggested and that worked.

thanks for everyones help
Ray

On Sunday, June 01, 2008 12:14 PM
Dave Peterson wrote:

You should read the post before responding to it.Ray found the solution.
You should read the post before responding to it.

Ray found the solution. It was not anything your program could fix.

Alan wrote:

--

Dave Peterson

On Tuesday, June 03, 2008 9:20 PM
Alan wrote:

THE PERSONAL.XLS work book not loading.
On May 30, 3:15=A0am, Ray wrote:
y,
l ...

Hi,

If necessary, you may need to look for some professional services. You
may try Advanced Excel Repair at http://www.datanumen.com/aer/ This
tool is rather useful in salvaging damaged Excel xls files

On Thursday, August 28, 2008 6:48 AM
Andrew Burgi wrote:

THE PERSONAL.XLS work book not loading.
"Gord Dibben" wrote:


I have user with an identical issue, i have tried all of the suggestions
here but it still refuses to open personal.xls when double clicking an
existing file and isn't showing in disabled items.

any further suggestions?

Andy

On Thursday, August 28, 2008 9:56 AM
Gord Dibben wrote:

Next question is........where do you have Personal.xls stored?
Next question is........where do you have Personal.xls stored?

Is it in your XLSTART folder?

Can you open Personal.xls by double-clicking or by right-click and "Open"?

Are you sure it is not opened but hidden?


Gord

On Thu, 28 Aug 2008 03:48:14 -0700, Andrew Burgin <Andrew
wrote:

On Thursday, August 28, 2008 10:36 AM
AndrewBurgi wrote:

THE PERSONAL.XLS work book not loading.
It is stored in c:\documents and settings\username\application
data\microsoft\excel\xlstart

on opening excel from start menu its fine, opens as hidden, perfect

on opening an excel document, excel opens fine but personal.xls is not
loaded as a hidden or visible sheet and is not in disabled items.

i have tired the unreg and reg fix, recreated the macro in a new blank
personal.xls, added the file path to the open all items in this folder
section to no avail, makes no difference to the situation when opening
existing documents directly

"Gord Dibben" wrote:

On Thursday, August 28, 2008 11:17 AM
Dave Peterson wrote:

Just curious...What other files are in that XLStart folder?
Just curious...

What other files are in that XLStart folder?

In fact, do you have other XLStart folders (you may have more than one) and what
other files are in those?

Andrew Burgin wrote:

--

Dave Peterson

On Thursday, August 28, 2008 11:19 AM
Gord Dibben wrote:

Strange.Try one more.................
Strange.

Try one more.................uncheck "ignore other applications" in
ToolsOptionsGeneral.

If no joy maybe run a repair from HelpDetect and Repair.


Gord

On Friday, August 29, 2008 4:18 AM
AndrewBurgi wrote:

I've not managed to get hold of the user but from memmory there is also an
I've not managed to get hold of the user but from memmory there is also an
XLstart in program files but that folder is empty, i tried copying
personal.xls to it so both locations contained the same data bt the fault
continues.

"Gord Dibben" wrote:


Submitted via EggHeadCafe - Software Developer Portal of Choice
How to display a Gravatar Image with 100 Percent Client Script Code
http://www.eggheadcafe.com/tutorials...-gravatar.aspx