| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can't use scrollbars on large spreadsheet, they bounce back
we have to use arrow keys to manuever spreadsheet. very large spreadsheet,
last year got error message of "too many cell formats." questions: 1. would it make a difference to move up to v. 2003 (on 2000 now) 2. what is causing problems 3. what else can be done to resolve this problem thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
can't use scrollbars on large spreadsheet, they bounce back
Hayden,
do a Google search of "too many cell formats" and you will see lots of postings about this. Hope this helps. Pete Hayden Lee wrote: we have to use arrow keys to manuever spreadsheet. very large spreadsheet, last year got error message of "too many cell formats." questions: 1. would it make a difference to move up to v. 2003 (on 2000 now) 2. what is causing problems 3. what else can be done to resolve this problem thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
can't use scrollbars on large spreadsheet, they bounce back
Hi, Pete,
Thanks, but I can't find anything to help with the problem with the scroll bars. I now understand why we got the "too many cell formats" before and we can correct that, but the scrollbars still "stick." Hayden "Pete_UK" wrote: Hayden, do a Google search of "too many cell formats" and you will see lots of postings about this. Hope this helps. Pete Hayden Lee wrote: we have to use arrow keys to manuever spreadsheet. very large spreadsheet, last year got error message of "too many cell formats." questions: 1. would it make a difference to move up to v. 2003 (on 2000 now) 2. what is causing problems 3. what else can be done to resolve this problem thanks |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
can't use scrollbars on large spreadsheet, they bounce back
I'm not sure what the problem is - I suggest that you clear the cell
formats first and see if you still have the problem. I use XL2000, sometimes with files of 25Mb, but have not encountered this problem. I'm not sure how "sticky" scrollbars relate to you using the arrow keys to move around. Pete Hayden Lee wrote: Hi, Pete, Thanks, but I can't find anything to help with the problem with the scroll bars. I now understand why we got the "too many cell formats" before and we can correct that, but the scrollbars still "stick." Hayden "Pete_UK" wrote: Hayden, do a Google search of "too many cell formats" and you will see lots of postings about this. Hope this helps. Pete Hayden Lee wrote: we have to use arrow keys to manuever spreadsheet. very large spreadsheet, last year got error message of "too many cell formats." questions: 1. would it make a difference to move up to v. 2003 (on 2000 now) 2. what is causing problems 3. what else can be done to resolve this problem thanks |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
can't use scrollbars on large spreadsheet, they bounce back
Hi, Pete,
Thanks, but the cell format error msg did not come up again now. When we grab the vertical scroll bar, for example, and pull it down, it always bounces back to the top of the bar and the spreadsheet won't scroll down. Same thing w/the horizontal scroll bar. It is particularly bad when we are trying to highlight a section wherein we need the scroll bars. We can go to another cell, page or section of the spreadsheet using the arrow keys, but we can't highlight it that way. Hayden "Pete_UK" wrote: I'm not sure what the problem is - I suggest that you clear the cell formats first and see if you still have the problem. I use XL2000, sometimes with files of 25Mb, but have not encountered this problem. I'm not sure how "sticky" scrollbars relate to you using the arrow keys to move around. Pete Hayden Lee wrote: Hi, Pete, Thanks, but I can't find anything to help with the problem with the scroll bars. I now understand why we got the "too many cell formats" before and we can correct that, but the scrollbars still "stick." Hayden "Pete_UK" wrote: Hayden, do a Google search of "too many cell formats" and you will see lots of postings about this. Hope this helps. Pete Hayden Lee wrote: we have to use arrow keys to manuever spreadsheet. very large spreadsheet, last year got error message of "too many cell formats." questions: 1. would it make a difference to move up to v. 2003 (on 2000 now) 2. what is causing problems 3. what else can be done to resolve this problem thanks |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
can't use scrollbars on large spreadsheet, they bounce back
If you hold down the <SHIFT key while pressing the arrow keys this
allows you to highlight a range - same with Page Down/Up. You can also use the F5 key (GoTo) if you know what cell you want to move to. I have encountered the problem you describe with scroll bars before, but I can't remember what I did to rectify it (if anything). It might have been with XL97. Does the sheet scroll if you click in the scroll bar? Not sure if this helps. Pete Hayden Lee wrote: Hi, Pete, Thanks, but the cell format error msg did not come up again now. When we grab the vertical scroll bar, for example, and pull it down, it always bounces back to the top of the bar and the spreadsheet won't scroll down. Same thing w/the horizontal scroll bar. It is particularly bad when we are trying to highlight a section wherein we need the scroll bars. We can go to another cell, page or section of the spreadsheet using the arrow keys, but we can't highlight it that way. Hayden "Pete_UK" wrote: I'm not sure what the problem is - I suggest that you clear the cell formats first and see if you still have the problem. I use XL2000, sometimes with files of 25Mb, but have not encountered this problem. I'm not sure how "sticky" scrollbars relate to you using the arrow keys to move around. Pete Hayden Lee wrote: Hi, Pete, Thanks, but I can't find anything to help with the problem with the scroll bars. I now understand why we got the "too many cell formats" before and we can correct that, but the scrollbars still "stick." Hayden "Pete_UK" wrote: Hayden, do a Google search of "too many cell formats" and you will see lots of postings about this. Hope this helps. Pete Hayden Lee wrote: we have to use arrow keys to manuever spreadsheet. very large spreadsheet, last year got error message of "too many cell formats." questions: 1. would it make a difference to move up to v. 2003 (on 2000 now) 2. what is causing problems 3. what else can be done to resolve this problem thanks |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
can't use scrollbars on large spreadsheet, they bounce back
Hi, Pete,
Thanks. I can use the shift key to highlight, that helps for now. As for clicking the scroll bars, no, they do not move. The bars just click from black to white but nothing happens. We've ordered Excel 2003 and we'll try that. Hayden "Pete_UK" wrote: If you hold down the <SHIFT key while pressing the arrow keys this allows you to highlight a range - same with Page Down/Up. You can also use the F5 key (GoTo) if you know what cell you want to move to. I have encountered the problem you describe with scroll bars before, but I can't remember what I did to rectify it (if anything). It might have been with XL97. Does the sheet scroll if you click in the scroll bar? Not sure if this helps. Pete Hayden Lee wrote: Hi, Pete, Thanks, but the cell format error msg did not come up again now. When we grab the vertical scroll bar, for example, and pull it down, it always bounces back to the top of the bar and the spreadsheet won't scroll down. Same thing w/the horizontal scroll bar. It is particularly bad when we are trying to highlight a section wherein we need the scroll bars. We can go to another cell, page or section of the spreadsheet using the arrow keys, but we can't highlight it that way. Hayden "Pete_UK" wrote: I'm not sure what the problem is - I suggest that you clear the cell formats first and see if you still have the problem. I use XL2000, sometimes with files of 25Mb, but have not encountered this problem. I'm not sure how "sticky" scrollbars relate to you using the arrow keys to move around. Pete Hayden Lee wrote: Hi, Pete, Thanks, but I can't find anything to help with the problem with the scroll bars. I now understand why we got the "too many cell formats" before and we can correct that, but the scrollbars still "stick." Hayden "Pete_UK" wrote: Hayden, do a Google search of "too many cell formats" and you will see lots of postings about this. Hope this helps. Pete Hayden Lee wrote: we have to use arrow keys to manuever spreadsheet. very large spreadsheet, last year got error message of "too many cell formats." questions: 1. would it make a difference to move up to v. 2003 (on 2000 now) 2. what is causing problems 3. what else can be done to resolve this problem thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do you find a excel spreadsheet that you replaced with a new | Excel Worksheet Functions | |||
| calling a C++ program from Excel 2000 and passing a result from C++ back to an excel spreadsheet | Excel Discussion (Misc queries) | |||
| Application to turn a table layout webpage back into a spreadsheet? | Excel Discussion (Misc queries) | |||
| how do I make a word typed in a cell go to a specific cell in anot | Excel Discussion (Misc queries) | |||
| How to sort/update large excel db | Excel Discussion (Misc queries) | |||
Linear Mode
