Johnny
Undoubtedly there are issues with speed in Excel 2007, particularly with
shapes and charts. However there are some things to note
Excel in compatibility mode (Xl97-2003) files will be slower
If you do not have a dual core processor turn off multi-threading
calculation
Upgrade your personal.xls, sheet.xls, book.xls, etc
Unload any add-ins. Particularly those of third parties
Use the xlsb file format for speed of opening/calc
Check any Office plug-ins operating with your AV software
Newly built, new format files will be significantly faster than 'converted
ones'
If you are using .xlsx and docx files for your copy paste, I would be
staggered if the file sizes were bigger as the files are now plain text
(xml) in a zipped archive. (My thought is you are trying to retain
compatibility with older formats)
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
web: www.nickhodge.co.uk
blog (non-tech):
www.nickhodge.co.uk/blog/
"JohnnyG" wrote in message
...
I have upgraded from Excel 2003 to Excel 2007 and am experiencing a
tremendous decrease in speed. The following speed comparisons were done on
the same machinewith the same file containing about 50 columnsx 5000 rows
of
data and 7 charts of the data.
Time to select 4 charts:
Excel 2003: 4 seconds
Excel 2007: 57 seconds
Time to copy the 4 selected charts and paste them into Words 2007:
Excel 2003: 18 seconds
Excel 2007: 60 seconds
Finally, when saving the Word file in .doc format with the same graphs
pasted from the same excel file, here are the file sizes:
Graphs from Excel 2003: 187K
Graphs from Excel 2007: 235k
Is there any way to speed up Excel 2007? And why are the Word files
larger?
This is a problem because we zip up a number of word files and send them
via
email - the same files with graphs from Excel 2007 are now too large to
send
in one email.
Thanks,
John