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?