I have a user at my job, that when she logs in to her account to use the
excel sheet she needs, excel starts, shows the entire sheet and then quot;causes
an error and needs to close.quot;
This started with her original machine quot;98quot;, so I showed her how to run
excel in safe mode and that worked for about a week.
Knowing this was a temp fix, I quot;rebuiltquot; a machine with 2000 pro. Did all
the updates, office and service packs, all the critical updates and
everything under the sun I could find.
So I test out the quot;newquot; machine and under admin logon, tada it works. Logon
as her and same error.!!!!!!!!!!!! The file is located on a server, so I
logon as my real name user, which has normal user rights and tada it works.
I then go to my fellow IT coworkers and on thier machines open the file
under their name and tada it works.
Gets Better......
I create a NEW USER ACCOUNT for this person and tada it works. I give her
the new machine, new account logon and all is well.
Fast forward 3 days and quess what ????
She has FULL access to this file and everyone else mentioned earlier can
still open this file with no problem.
What in the world can she be doing that this file does not work under her
logon????????????????????????????????????????????? ???????
Any tada's in any direction is welcome.
2000 servers w/ EX2003 and a proxy just incase
Bondo
Just a guess...
The last time I got an error like this it was caused by a corrupt *.xlb
file--where excel stores your customized changes to any of the toolbars.
You could check if it is the toolbar file by:
close excel
windows search
search for *.xlb
(in hidden folders for hidden files, too)
Rename all the *.xlb files you find to *.xlbOLD
Then restart excel and see if that helps.
If it does, then rebuild any customized changes to the toolbar at your
convenience.
If it doesn't, then close excel and rename all those *.xlbOLD back to *.xlb.
Chip Pearson has some notes on how to diagnose startup errors at:
www.cpearson.com/excel/StartupErrors.htm
And Jan Karel Pieterse has more notes at:
www.jkp-ads.com/Articles/StartupProblems.htm
bondo wrote:
gt;
gt; I have a user at my job, that when she logs in to her account to use the
gt; excel sheet she needs, excel starts, shows the entire sheet and then quot;causes
gt; an error and needs to close.quot;
gt; This started with her original machine quot;98quot;, so I showed her how to run
gt; excel in safe mode and that worked for about a week.
gt; Knowing this was a temp fix, I quot;rebuiltquot; a machine with 2000 pro. Did all
gt; the updates, office and service packs, all the critical updates and
gt; everything under the sun I could find.
gt; So I test out the quot;newquot; machine and under admin logon, tada it works. Logon
gt; as her and same error.!!!!!!!!!!!! The file is located on a server, so I
gt; logon as my real name user, which has normal user rights and tada it works.
gt; I then go to my fellow IT coworkers and on thier machines open the file
gt; under their name and tada it works.
gt; Gets Better......
gt; I create a NEW USER ACCOUNT for this person and tada it works. I give her
gt; the new machine, new account logon and all is well.
gt; Fast forward 3 days and quess what ????
gt; She has FULL access to this file and everyone else mentioned earlier can
gt; still open this file with no problem.
gt; What in the world can she be doing that this file does not work under her
gt; logon????????????????????????????????????????????? ???????
gt; Any tada's in any direction is welcome.
gt; 2000 servers w/ EX2003 and a proxy just incase
gt;
gt; Bondo
--
Dave Peterson
Just a thought with no simple idea ...
Check the computer for the persons old user name/account/password. she may
be changing the password back to her old one.
Also, ask her what changes she is making to her account. She might putting
in old software or screensavers.- -Markquot;bondoquot; wrote:
gt; I have a user at my job, that when she logs in to her account to use the
gt; excel sheet she needs, excel starts, shows the entire sheet and then quot;causes
gt; an error and needs to close.quot;
gt; This started with her original machine quot;98quot;, so I showed her how to run
gt; excel in safe mode and that worked for about a week.
gt; Knowing this was a temp fix, I quot;rebuiltquot; a machine with 2000 pro. Did all
gt; the updates, office and service packs, all the critical updates and
gt; everything under the sun I could find.
gt; So I test out the quot;newquot; machine and under admin logon, tada it works. Logon
gt; as her and same error.!!!!!!!!!!!! The file is located on a server, so I
gt; logon as my real name user, which has normal user rights and tada it works.
gt; I then go to my fellow IT coworkers and on thier machines open the file
gt; under their name and tada it works.
gt; Gets Better......
gt; I create a NEW USER ACCOUNT for this person and tada it works. I give her
gt; the new machine, new account logon and all is well.
gt; Fast forward 3 days and quess what ????
gt; She has FULL access to this file and everyone else mentioned earlier can
gt; still open this file with no problem.
gt; What in the world can she be doing that this file does not work under her
gt; logon????????????????????????????????????????????? ???????
gt; Any tada's in any direction is welcome.
gt; 2000 servers w/ EX2003 and a proxy just incase
gt;
gt; Bondo
- Jan 24 Wed 2007 20:35
All MVP's, Try this one
close
全站熱搜
留言列表
發表留言