Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 02-08-2013, 06:01 PM
MJP143 MJP143 is offline Windows XP Office 2003
Novice
 
Join Date: Feb 2013
Posts: 1
MJP143 is on a distinguished road
Smile object variable or with block variable not set


Hello, I get the following error when pressing the "save" icon on the toolbar in Excel: object variable or with block variable not set. I am only able to save a document by hitting "Control S" or going to "file/save". This all started when I got a new computer a month ago. I am not very techy and have gone to our IT department 6 times and all they do is reset/restore my profile, which is almost more annoying than not being able to save because I have to redo all my settings AND it never solves my Excel problem. I can't be the first person out there to have this happen Please help! I will take any advice I get here and ask my company IT department to try it.
Reply With Quote
  #2  
Old 02-11-2013, 05:07 AM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 18,616
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

Hi MJP,

I suspect the problem is caused by a faulty 3rd-party addin, or perhaps a faulty Office installation on your PC. The only other likely source of error is a faulty Excel template that loads whenever Excel starts. Simply resetting/recreating your profile won't fix any of these problems.

You can test whether an Addin or template is at fault by holding down the Ctrl key when you start Excel. This prevents them loading. If Excel works fine in 'safe' mode, you know to start looking at your templates & Addins. If it's no different, your Office installation is most likely faulty.

For template issues, check out what files are listed in the folder referenced in File|Options|Advanced>General>"At startup, open all files listed in". Move any files in that folder to another folder, then re-start Excel. If the problem goes away, the culprit is one or more of those files.

To see what, 3rd-party addins are installed, go to File|Options|Addins. Try deactivating them one at a time, so as to identify which, if any, is faulty. Then get your IT dept to uninstall, then reinstall, the faulty Addin, if there is one.

For a faulty Office installation, have your IT dept repair it (via Programs & Features > Microsoft Office > Change in the Windows Control Panel).
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Run-time error '91': Object variable or With block variable not set tinfanide Excel Programming 2 06-10-2012 10:17 AM
variable Page references scrinmemphis Word 4 06-06-2012 11:50 PM
Capture a Font in a Variable joatmon Excel Programming 1 05-30-2012 08:23 PM
XML parsing & Object variable not set (Error 91) tinfanide Excel Programming 0 12-29-2011 08:43 AM
Variable fields? Emalee77 PowerPoint 0 01-30-2011 05:58 PM


All times are GMT -7. The time now is 05:00 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft