Excel 2007 !#@%&*^#!!!!!!!!

JAHoff

New Member
Joined
Mar 2, 2007
Messages
17
I migrated an old EXCEL 2002 file which contains 8 'complicated' charts into EXCEL 2007. Each chart consists of 6 data series of ~900 points. I have macros which change the data that is plotted using simple math....i.e. the data ranges remain the same but the data change. All of the charts have a date range for the X axis so I have macros to change the range on all so that they are the same. In ver2002 the charts update with these macros with very little delay (<1 sec). In ver2007 these updates can take over 15sec...likewise when I try to manually edit one of these charts it often takes over 5sec to 'grab' focus on the part of the chart I want to edit (series, axis). I've tried regenerating the charts by bringing the data into ver2007 and creating the charts but once I get the data plotted everything slows down. At present ver2007 is almost useless for most of my charting applications because editing takes so **** long. Is anyone else experiencing this.

Sorry if a similar thread has been posted. Point me to those threads if you can.

Cheers JAH
 

Some videos you may like

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

oaishm

Board Regular
Joined
Jan 30, 2009
Messages
97
2007 is significantly slower than anything I have ever seen. I avoid it like the plague. I hope I get promoted to a point where I don't have to use excel anymore by the time 2007 is prevalant. I'm sure lotus 123 people thought the same thing in 1992
 

Watch MrExcel Video

Forum statistics

Threads
1,122,840
Messages
5,598,386
Members
414,234
Latest member
grlevesq

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top