Thanks for suggestion and reply.
The spreadsheet tracks finances so I have a saved copy for every month.
Went back to pre-2007 Office install and opened a workbook from Nov 08
Opened Excel, opened the 2003 xlx file and saved as XLS, closed Excel
Opened Excel, opened the 2003 xlx file and saved as XLSM, closed Excel
Opened Excel, opened the 2003 xlx file and saved as XLSX, closed Excel
Opened Excel and in an empty cell typed = then went to a different
worksheet in this workbook, selected a cell and hit enter.
Attempted to do this extremely simple "calculation" for each file format. In
each case I gave up after 1:15 wait.
(Comment when you do this, are we supposed to see the formula appear while
still at the sheet I am copying the cell from?)
After waiting over a minute I attempted to shut the program down. In each
case the program locked up so it took a forced close in each case.
After doing this I attempted to open IE to return to this site but now my PC
was running very slow. Did a re-boot. Had problems starting after re-boot.
Did second re-boot and now the PC seems back to normal.
If I cna't get this "Improved" version of Excell to work I will probably do
complete un-install and offer the license to some unsuspecting fool.
"JLatham" wrote:
Make a copy of your original Excel 2003 .xls file.
How does that copy perform when opened in Excel 2007 and is running in
'Compatibility Mode'?
I suggest this just as a benchmark between the two files (.xls and .xlsm).
If the times are significantly different, then the attempt to convert it to
2007 format may have corrupted it.
If the times are similar, it may be that the added time to complete is being
caused by Excel 2007 recalculating the other formulas in the workbook - in
which case there may not be much to be done to help other than trying to make
the workbook more efficient. There may be help/guidance in doing that at
www.decisionmodels.com and other sites. Be sure you work with a copy of your
workbook in making any such changes so that if bad things happen you have an
easy road to recovery.
"Roger" wrote:
Sorry for typo.
Yes I am working in xlsm type file.
Example
Saved & closed the file.
Started Excel
Opened the file
Clicked a single row and hit delete
Did nothing else
1:35 to delete the row.
"Shane Devenshire" wrote:
Hi,
You have created a new file type xlsxm you should be using xlsm (four
digit last name.)
Then close the file and reopen it, below the ribbon you should see the
Security Bar, click Options, and choose Enable this content...
--
If this helps, please click the Yes button.
Cheers,
Shane Devenshire
"Roger" wrote:
I have been running an involved spreadsheer for a number of years. Couple of
macros (not automatic) and lots of formula. Ran with few if any problems
under Excel 97 and 2003.
I am trying to run the same spreadsheet in 2007 and it just doesn't work.
I have gone to Trust Center and enabled macros ( The wording could lead one
to believe that Excel should not have macros)
Open the original 4MB .xls file
If I try and save it as xlsx I get warning about not being able to save in
macro-free file because of the VB project.
I try to save as macro-enabled xlsxm
When I re-open the xlsxm file every task such as row incert or cell copy
takes over a minute to complete.
I note that this xlsxm file is only 800k so do not know what happened to the
3.2MB worth of information.
How can I run macros under 2007?