Excel 2010/Win XP SP3 - 'Save As' on local machine
Per Ardua ad Astraeus
Thread Starter
Join Date: Mar 2000
Location: UK
Posts: 18,579
Likes: 0
Received 0 Likes
on
0 Posts
Excel 2010/Win XP SP3 - 'Save As' on local machine
I was running quite happily until a couple of weeks ago. I need to highlight a sheet and 'save as' to another folder. It started locking up and needed Task Manger to unlock - and kill Excel. I cannot even open the folder in which I wish to 'save as'. Works OK in Word.
Re-installed Office 2010 and it still happens. Internet full of similar problems with no answer from M$. Anyone know a fix?
PS I save in xls for backward compat. 'Save as' in xlsx goes little further and then locks up.
Re-installed Office 2010 and it still happens. Internet full of similar problems with no answer from M$. Anyone know a fix?
PS I save in xls for backward compat. 'Save as' in xlsx goes little further and then locks up.
Per Ardua ad Astraeus
Thread Starter
Join Date: Mar 2000
Location: UK
Posts: 18,579
Likes: 0
Received 0 Likes
on
0 Posts
Milo - no, but I eventually worked my way through several of the answers and arrived at 'reduce the number saved documents' to 5 which seems to have worked! Bizarre!
Join Date: Jan 2012
Location: .
Posts: 2,173
Likes: 0
Received 0 Likes
on
0 Posts
strange
what I was going to say related to a rare problem where windows software is interfered with by the HP networking software constantly looking for the scanner and memory card slots. When you try to save a document, windows explorer freezes.
just as well it wasn't that as off-hand I can't remember how to fix it.....Kodak printers have a similar failing where their networking service drags explorer to a halt, but thats easy to fix
what I was going to say related to a rare problem where windows software is interfered with by the HP networking software constantly looking for the scanner and memory card slots. When you try to save a document, windows explorer freezes.
just as well it wasn't that as off-hand I can't remember how to fix it.....Kodak printers have a similar failing where their networking service drags explorer to a halt, but thats easy to fix
Per Ardua ad Astraeus
Thread Starter
Join Date: Mar 2000
Location: UK
Posts: 18,579
Likes: 0
Received 0 Likes
on
0 Posts
Hmm! The world of 'puters!!
No, I have however had another 'issue' with HP printers where a lady I have set up with a domain address to handle stuff for a charity had some sort of 'upgrade' to an HP printer done by her son and it knocked out the Outlook email settings for the address (which had worked) and still worked on my Outlook. No network. Absolutely no way round it. Just about to delete the a/c settings and start again when it started up all on its own................
No, I have however had another 'issue' with HP printers where a lady I have set up with a domain address to handle stuff for a charity had some sort of 'upgrade' to an HP printer done by her son and it knocked out the Outlook email settings for the address (which had worked) and still worked on my Outlook. No network. Absolutely no way round it. Just about to delete the a/c settings and start again when it started up all on its own................
Join Date: Jan 2012
Location: .
Posts: 2,173
Likes: 0
Received 0 Likes
on
0 Posts
have you got any mapped links to network drives on that machine? Try deleting them
On older versions of Office this was an issue - it may give some clues
Microsoft Office stops responding when you try to open or save a file
in your case it could be worth trying this, though its not exactly your problem
You cannot save documents to a folder or change the permission settings of folders on a SMB 1.0-based remote server from a Windows-based computer that has security update 980232 (MS10-020) installed
On older versions of Office this was an issue - it may give some clues
Microsoft Office stops responding when you try to open or save a file
in your case it could be worth trying this, though its not exactly your problem
You cannot save documents to a folder or change the permission settings of folders on a SMB 1.0-based remote server from a Windows-based computer that has security update 980232 (MS10-020) installed
Per Ardua ad Astraeus
Thread Starter
Join Date: Mar 2000
Location: UK
Posts: 18,579
Likes: 0
Received 0 Likes
on
0 Posts
No, no network drives. File save in this case is to Fat32 drive for particular reason so cannot alter permissions as far as I know?
What is puzzling is that having set Excel to '5 recent docs' I looked in 'Open'/Recent Docs and found a lot which I have cleared. Will check Word as well.
It is disappointing that M$ appear to have ignored this raft of complaints about Office 2007/10!
What is puzzling is that having set Excel to '5 recent docs' I looked in 'Open'/Recent Docs and found a lot which I have cleared. Will check Word as well.
It is disappointing that M$ appear to have ignored this raft of complaints about Office 2007/10!
Per Ardua ad Astraeus
Thread Starter
Join Date: Mar 2000
Location: UK
Posts: 18,579
Likes: 0
Received 0 Likes
on
0 Posts
Further info: The 'save As' problem (in Excel so far) ONLY happens when I 'save As' to a different folder n the same drive. Saving to the same folder with different name or ext works ok.
Join Date: Jan 2012
Location: .
Posts: 2,173
Likes: 0
Received 0 Likes
on
0 Posts
any chance that Office File Validation has somehow been enabled?
Office File Validation for Office 2003 and Office 2007
theres a way to turn it off - last but one reg hack in that link
Office File Validation for Office 2003 and Office 2007
theres a way to turn it off - last but one reg hack in that link
Per Ardua ad Astraeus
Thread Starter
Join Date: Mar 2000
Location: UK
Posts: 18,579
Likes: 0
Received 0 Likes
on
0 Posts
I have found the M$ registry hack for both recent files and recent places in 2010. I found 50 'files' listed in the Excel reg file folder although the programme interface had been at 'max 5' for a week(!). I also found 25 files in the Word file reg folder although again it had been at 5 for several days. It looks as if Office is not clearing the file cache when the limit is changed.
So far while not quite normal, save as has improved.
So far while not quite normal, save as has improved.
Per Ardua ad Astraeus
Thread Starter
Join Date: Mar 2000
Location: UK
Posts: 18,579
Likes: 0
Received 0 Likes
on
0 Posts
Further - no, that did not fix it. However, something Milo asked prompted me to look at my network drives where lo! I found d.docs (Skydrive). Not knowingly placed by me, but deleting it seems to have cleared almost all the issues. (????)
Join Date: Jan 2012
Location: .
Posts: 2,173
Likes: 0
Received 0 Likes
on
0 Posts
yep, mapping a drive letter to a (very) remote server like a Skydrive would fit that earlier Microsoft scenario quite well
The polling time could be quite a problem....
theres another thing that may help in a case like that: turning the Webclient service to "automatic", not "manual"
The polling time could be quite a problem....
theres another thing that may help in a case like that: turning the Webclient service to "automatic", not "manual"
Per Ardua ad Astraeus
Thread Starter
Join Date: Mar 2000
Location: UK
Posts: 18,579
Likes: 0
Received 0 Likes
on
0 Posts
I don't even remember using Skydrive in the last 2 years, and it is a puzzle why it was only affecting Office - all other 'Save As' functions were fine. Anyway, many thanks for the tip (I missed earlier!) - "Network drive - nah - don't have any of those..........."
Guest
Join Date: May 2008
Location: Somewhere between E17487 and F75775
Age: 80
Posts: 725
Likes: 0
Received 0 Likes
on
0 Posts
windows software is interfered with by the HP
Including stopping WIN XP SP3 going into standby ! message attributes the failure to HP printer s/w. Hitting close and standby a second time solves the problem and XP goes to sleep.
I hope you all realise that solving these problems is a great dementia-fighter ! Keeps the old brain cells going. Perhaps inserted deliberately by HP and others as a public service.
Including stopping WIN XP SP3 going into standby ! message attributes the failure to HP printer s/w. Hitting close and standby a second time solves the problem and XP goes to sleep.
I hope you all realise that solving these problems is a great dementia-fighter ! Keeps the old brain cells going. Perhaps inserted deliberately by HP and others as a public service.
Join Date: Nov 2000
Location: Cambridge, England, EU
Posts: 3,443
Likes: 0
Received 1 Like
on
1 Post
Another wonderful "feature" of HP printer driver software can be that if you've got a network connected printer which you haven't switched on, because why burn the carbon when you don't want to print anything just right now, then doing almost anything on the machine hangs for a couple of minutes whilst the printer driver tries to find the printer.
Join Date: Jan 2012
Location: .
Posts: 2,173
Likes: 0
Received 0 Likes
on
0 Posts
its probably not the printer driver - the hang is usually because the PC can't find the slots for the photocards - which are usually mapped as network drives.....
back to a similar problem as BOAC had
Its fixable by disabling an HP network service, but offhand I can't remember just what. Its the problem I alluded to in my first reply to BOAC
Something similar is probably behind the standby issue mentioned above, but HPs are a pain like that anyway. Surprising how many computers hang at shutdown because an HP printer service (usually HPZsomething or other) fails to close
back to a similar problem as BOAC had
Its fixable by disabling an HP network service, but offhand I can't remember just what. Its the problem I alluded to in my first reply to BOAC
Something similar is probably behind the standby issue mentioned above, but HPs are a pain like that anyway. Surprising how many computers hang at shutdown because an HP printer service (usually HPZsomething or other) fails to close
Last edited by Milo Minderbinder; 13th Sep 2012 at 16:39.
Per Ardua ad Astraeus
Thread Starter
Join Date: Mar 2000
Location: UK
Posts: 18,579
Likes: 0
Received 0 Likes
on
0 Posts
Hey! I'm back with the same problem.
Today to try and sort it I stripped out Office 2010 and reinstalled 2003. In that I can zip around directories and folders during 'Open' and 'Save As' like no tomorrow. Emboldened by this I stripped out 2003 and put back a full 2010. I now cannot do that. If I select 'Open' it naturally opens in the chosen docs folder. Selecting 'My Computer' from the sidebar produces the M$ torch waving around and 'not responding' in task manager and ultimately it has to 'Force Word/Excel to close' and report to M$ etc etc.
Does anyone know what has changed here between 2003 and 2010 and more importantly how to sort it? I cannot work out the correct term for Google to describe the problem either!
Today to try and sort it I stripped out Office 2010 and reinstalled 2003. In that I can zip around directories and folders during 'Open' and 'Save As' like no tomorrow. Emboldened by this I stripped out 2003 and put back a full 2010. I now cannot do that. If I select 'Open' it naturally opens in the chosen docs folder. Selecting 'My Computer' from the sidebar produces the M$ torch waving around and 'not responding' in task manager and ultimately it has to 'Force Word/Excel to close' and report to M$ etc etc.
Does anyone know what has changed here between 2003 and 2010 and more importantly how to sort it? I cannot work out the correct term for Google to describe the problem either!