Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-08-2013, 06:01 PM
MJP143 MJP143 is offline object variable or with block variable not set Windows XP object variable or with block variable not set Office 2003
Novice
object variable or with block variable not set
 
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 object variable or with block variable not set Windows 7 64bit object variable or with block variable not set Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
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
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
object variable or with block variable not set Run-time error '91': Object variable or With block variable not set tinfanide Excel Programming 2 06-10-2012 10:17 AM
object variable or with block variable not set variable Page references scrinmemphis Word 4 06-06-2012 11:50 PM
object variable or with block variable not set 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

Other Forums: Access Forums

All times are GMT -7. The time now is 02:49 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft