Solved

How can I stop "Undo" across multiple spreadsheets?

Posted on 2011-02-16
8
2,303 Views
Last Modified: 2012-05-11
When I am working between multiple separate workbooks in Excel 2010, Undo will work backwards across all of the workbooks that I have open.  How do I get the Undo function to work only on the workbooks that I am currently in?  Noticed this is not a problem in Word 2010 only Excel 2010 nor does it happen in Office 2003 (I don't know about 2007).  
0
Comment
Question by:eshurak
  • 3
  • 2
  • 2
  • +1
8 Comments
 
LVL 90

Expert Comment

by:John Hurst
Comment Utility
I don't think that happens to me, and I don't see an option to set or unset. Try running Excel in Safe Mode (no addins) to see if an add-in is causing the issue. ... Thinkpads_User
0
 
LVL 90

Expert Comment

by:John Hurst
Comment Utility
I looked again through all the options. Try doing an Office Repair. From Control Panel -> Add/Remove | Programs/Features -> Select Office -> Change and then repair.  ... Thinkpads_User
0
 
LVL 23

Accepted Solution

by:
Michael74 earned 500 total points
Comment Utility
I just did a test in Excel 2003 and the issue you described is happening. I think the only to solve this would be to open each excel in a new session.

Have a look at this article

http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/A_1007-Option-to-open-excel-2007-documents-in-a-new-instance.html?sfQueryTermInfo=1+10+2007+30+excel+new+open

From this link -

Problems we all know excel has
Many people are tired of the way excel workbooks are affected by every other workbook you have opened. When you calculate one, they all calculate.  Excel acts as though they are inter-dependent when they really aren't.  Well with a simple registry injection, you can add a right click menu to the shell that lets you open excel in a new instance instead of just opening another excel workbook in the same window as any existing one.

Another link showing you how to open excel as separate sessions

http://brett.batie.com/software-development/open-excel-in-multiple-windows/

Michael
0
 
LVL 41

Expert Comment

by:dlmille
Comment Utility
Good tip...

Or you can just run Excel from the start menu as many times as you want instances.  At least that's how my setup works

:)

Dave
0
Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

 
LVL 3

Author Comment

by:eshurak
Comment Utility
Thanks Michael,  I'll look into those.  They mostly seem to be for older versions of Office not 2010 so some modifications will have to be made unless we find a 2010 solution.
0
 
LVL 23

Expert Comment

by:Michael74
Comment Utility
eshurak

This solution
http://brett.batie.com/software-development/open-excel-in-multiple-windows/

will work for 2010 as is

Michael
0
 
LVL 3

Author Comment

by:eshurak
Comment Utility
For some reason it's not working for me.  The download for the msi just opens a text file and the one with the zip is not installing a program on my PC to select for step 2 in his directions.  I'm using winXP.
0
 
LVL 23

Expert Comment

by:Michael74
Comment Utility
The file has been posted as "Install_runExcel.msi.txt" and so you need to remove the .txt

You may need to display hidden file extensions
http://www.wikihow.com/Disable-Hidden-File-Extensions-in-Windows-XP

Michael

0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
Outlook Free & Paid Tools
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now