How to get 2003 Excel spreadsheets to run smoothly in 2007 Excel?.

[Fulliving]

I created a Planner in Excel 2003, and have upgraded to Excel 2007. The
planner opens fine in 2007, but I cannot readily scroll down through a sheet,
as it scrolls 1 row by 1 row.

I can save in both .xls and .xlsx, but each runs poorly as noted above.

Any advice ?

Thank You

MFDayton

 

[Gary Keramidas]

you didn't say if it was using the mouse wheel or if it was on a different
pc or not. but check the mouse settings in control panel. adjust the
vertical scrolling speed.

if not, i'm not sure what you mean.

 

[Bill Sharpe]

I created a Planner in Excel 2003, and have upgraded to Excel 2007. The
planner opens fine in 2007, but I cannot readily scroll down through a sheet,
as it scrolls 1 row by 1 row.

I can save in both .xls and .xlsx, but each runs poorly as noted above.

Any advice ?

Thank You

MFDayton

Does this slowdown occur only with your planner or with all Excel 2007
spreadsheets?

Bill

 

[Fulliving]

Does this slowdown occur only with your planner or with all Excel 2007
spreadsheets?

Bill
.

Bill & Gary,
Thank you for your time to reply.

Increasing the mouse scroll speed helped a bit.

Oddly enough, the slow-down only occurs on 1 sheet of an Excel book of 6
sheets. The remaining sheets scroll fine. The problem sheet is an array of
7 days x 53 weeks (with a text box between each week -- to add notes for the
week).

All my other .xls files run fine & can be saved in .xlsx & run fine.

I've thought about breaking the one sheet into 4 separate sheets of 3 months
per sheet, but the scroll is so slow, it won't scroll down to following weeks
to select and copy.

Thank you for your time,

Malcolm