| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Scrolling performance with filter in Excel 2003
I have a large file (1600 rows and columns to BN). When I use a filter (to
see just some of the rows) and try to scroll right, it slows ALOT around "X". I have tried reducing the number of rows, but same problem. I have tried removing shading, removing some columns, but no luck. I have other spreadsheets that are much larger that do not have this issue. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Scrolling performance with filter in Excel 2003
Out of curiosity, do you have the same issue without the filters? Is the
sheet actively calculating as you are attempting to scroll? (Look at bottom left of the file) "BethM" wrote: I have a large file (1600 rows and columns to BN). When I use a filter (to see just some of the rows) and try to scroll right, it slows ALOT around "X". I have tried reducing the number of rows, but same problem. I have tried removing shading, removing some columns, but no luck. I have other spreadsheets that are much larger that do not have this issue. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Scrolling performance with filter in Excel 2003
Thanks for your response! If I use NO filter, scrolling works fine.
There are no cacluations in this sheet (lower left says "12 of 1587" or "filter mode" only). "Sean Timmons" wrote: Out of curiosity, do you have the same issue without the filters? Is the sheet actively calculating as you are attempting to scroll? (Look at bottom left of the file) "BethM" wrote: I have a large file (1600 rows and columns to BN). When I use a filter (to see just some of the rows) and try to scroll right, it slows ALOT around "X". I have tried reducing the number of rows, but same problem. I have tried removing shading, removing some columns, but no luck. I have other spreadsheets that are much larger that do not have this issue. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Scrolling performance with filter in Excel 2003
No problem! So we've ruled out a few things. I know the file is large, but
you may want to copy the tab and paste special/values to another worksheet, then try filtering to see if it resolved the issue. "BethM" wrote: Thanks for your response! If I use NO filter, scrolling works fine. There are no cacluations in this sheet (lower left says "12 of 1587" or "filter mode" only). "Sean Timmons" wrote: Out of curiosity, do you have the same issue without the filters? Is the sheet actively calculating as you are attempting to scroll? (Look at bottom left of the file) "BethM" wrote: I have a large file (1600 rows and columns to BN). When I use a filter (to see just some of the rows) and try to scroll right, it slows ALOT around "X". I have tried reducing the number of rows, but same problem. I have tried removing shading, removing some columns, but no luck. I have other spreadsheets that are much larger that do not have this issue. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Scrolling performance with filter in Excel 2003
well, this worked!! I copied data to an entirely NEW document and manually
reformated. Don't know why - but it is fine now! thanks a ton! "Sean Timmons" wrote: No problem! So we've ruled out a few things. I know the file is large, but you may want to copy the tab and paste special/values to another worksheet, then try filtering to see if it resolved the issue. "BethM" wrote: Thanks for your response! If I use NO filter, scrolling works fine. There are no cacluations in this sheet (lower left says "12 of 1587" or "filter mode" only). "Sean Timmons" wrote: Out of curiosity, do you have the same issue without the filters? Is the sheet actively calculating as you are attempting to scroll? (Look at bottom left of the file) "BethM" wrote: I have a large file (1600 rows and columns to BN). When I use a filter (to see just some of the rows) and try to scroll right, it slows ALOT around "X". I have tried reducing the number of rows, but same problem. I have tried removing shading, removing some columns, but no luck. I have other spreadsheets that are much larger that do not have this issue. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Scrolling performance with filter in Excel 2003
the could have been some data from an external source that was messing you
up. Happy it was that easy! :-) "BethM" wrote: well, this worked!! I copied data to an entirely NEW document and manually reformated. Don't know why - but it is fine now! thanks a ton! "Sean Timmons" wrote: No problem! So we've ruled out a few things. I know the file is large, but you may want to copy the tab and paste special/values to another worksheet, then try filtering to see if it resolved the issue. "BethM" wrote: Thanks for your response! If I use NO filter, scrolling works fine. There are no cacluations in this sheet (lower left says "12 of 1587" or "filter mode" only). "Sean Timmons" wrote: Out of curiosity, do you have the same issue without the filters? Is the sheet actively calculating as you are attempting to scroll? (Look at bottom left of the file) "BethM" wrote: I have a large file (1600 rows and columns to BN). When I use a filter (to see just some of the rows) and try to scroll right, it slows ALOT around "X". I have tried reducing the number of rows, but same problem. I have tried removing shading, removing some columns, but no luck. I have other spreadsheets that are much larger that do not have this issue. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel 2003 spreadsheet scrolling | Excel Discussion (Misc queries) | |||
| how do you create an importance-performance chart in excel 2003? | Charts and Charting in Excel | |||
| Excel 2007 Beta Advanced Filter Performance | Excel Discussion (Misc queries) | |||
| Live Scrolling/Real-Time /Smooth Scrolling doesn't work for me in Excel 2003 | Excel Discussion (Misc queries) | |||
| Excel 2003 performance problems | Excel Discussion (Misc queries) | |||
Linear Mode
