Excel - Excel 2007 undo hazard
Asked By Hector
07-Jul-08 08:02 PM
Hi all,
I recently started using Excel... Excel 2007 actually... and one thing
I've noticed is that when you have several spreadsheets open in one
Excel 2007 instance and repeatedly invoke undo... expecting that it
will only undo the changes to the active spreadsheet so to speak...
you can inadvertently undo changes to the other spreadsheets that
are open in the background.
Does anyone know how to disable that particular "feature" and/or
force Excel to use a separate instance for each spreadsheet?
Excel 2007
(1)
Spreadsheets
(1)
Jim Rech replied...
Not new. Beware your expectations.
An 2007 change undo change is that a file, save does not empty the undo
stack. This is a deliberate feature that was much requested although, like
all new features, someone here complained about it. I forget why.
--
Jim
Excel INT defect: Please try this on 2007 for me Would someone who has Excel 2007 running on an Intel-compatible computer (i.e. not a Mac) please try the examples below and post your results here? I posted this inquiry to an Excel 2010 blog. Not sure if / when I will hear back from them. (Extra credit: If you have Excel 2010 running on an Intel-compatible computer, feel to try these examples and post your results here, too.) Has the following Excel 2003 problem been fixed in 2010 (or 2007)? INT(123456789 - 0.0000004) returns 123456789 instead of 123456788. This causes a problem in formulas
Excel Automation performance degradation in Excel 2007 I have a VB6 app that creates about 100 populated Excel spreadsheets. I have installed Office 2007 and the performance of the application has degraded significantly. On the same PC, extracting data same database, the creation process takes 50 seconds with Office 2003, but 165 seconds with Excel 2007. What is happening here? Why is Excel 2007 so slow? The application creates several hundred
Excel Opening Excel 2007 Binary Files (.xlsb) via OleDb ACE Hi Fellows, I found the Excel 2007 Binary format (with extension .xlsb) perfectly suitable for my needs, since it's fast to load and very compact. I deliver a bunch of reports in Excel that carries a lot of data, and those reports are actually being loaded with a where it stands that xlsb is supported by this provider, I converted the files in Excel, and then when trying to change then in the packages (just by changing the path I got the following error message: file was created in a previous beta version of Excel 2007. Open the file with Excel 2007 to save it to the most recent version
Excel Microsoft Excel I am quite impatient and would like to watch a tutorial on excel that takes one through the basics to advanced spreadsheet management. soes such a thing exist advanced" learning could take years like the rest of us are experiencing. Gord Dibben MS Excel MVP I can assure you that excel is very complex. You will learn little from watching a tutorial. The only way to learn Excel is by doing. I can guarantee you that you will never learn Excel by watching. The Step by Step books walk you through examples. You actually do them, step by step. I suggest you buy a books on Excel. The books are available at Barnes and Noble and also Amazon.com The starter books
Excel converting to dates. . . Hi. . . Excel 2007. When importing soccer results from another Excel spreadsheet it converts the data to dates. The result 1-1, with a dash, is tresfjording.com Once the conversion to a date is made there is no going back! Excel has stored the date as a number like 39782 for today. Can you get a as in '1-1? Can you make the file a TXT file and not have Excel do the automatic conversion? best wishes - - Bernard V Liengme Microsoft Excel MVP http: / / people.stfx.ca / bliengme remove caps from email well. . . I also wanted to there had to be a way to stop this behavior, if not it would render Excel useless for importing data from external sources. . . . . - - Vennlig hilsen Øyvind Granberg tresfjording@live.no www