![]() |
Scroll Bar in Shared workbook
I have a large spreadsheet and it will not allow me to scorll down. It will
only allow me to view aprox. the first 20 rows. When i use autofilter and filter to a certain area i can scroll. But 90% of the time i cannot scroll down anywhere. I created this shared workbook and it only start happening after a few times access the file. I also tired to unshare the workbook but it is doing the same thing. I am using Excel 2003. Please Help! Thank You |
Maybe....
If you applied window|freeze panes to your filtered list, maybe you put it in the wrong spot. I'd show all the data, then check window|freeze panes first. (Remove it and add it back correctly.) Ronil Patel wrote: I have a large spreadsheet and it will not allow me to scorll down. It will only allow me to view aprox. the first 20 rows. When i use autofilter and filter to a certain area i can scroll. But 90% of the time i cannot scroll down anywhere. I created this shared workbook and it only start happening after a few times access the file. I also tired to unshare the workbook but it is doing the same thing. I am using Excel 2003. Please Help! Thank You -- Dave Peterson |
You don't have freeze panes activated? If so click Windows then Unfreeze Panes
"Ronil Patel" wrote: I have a large spreadsheet and it will not allow me to scorll down. It will only allow me to view aprox. the first 20 rows. When i use autofilter and filter to a certain area i can scroll. But 90% of the time i cannot scroll down anywhere. I created this shared workbook and it only start happening after a few times access the file. I also tired to unshare the workbook but it is doing the same thing. I am using Excel 2003. Please Help! Thank You |
All times are GMT +1. The time now is 02:15 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com