| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 79997 | 2007-06-08 04:40:00 | Excel 97 slow to move from cell | Strummer (8836) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 557090 | 2007-06-08 04:40:00 | This problem has just started recently. I have a few columns that are conditonally formatted so the cell colour will changed to one of two colours when certain data is entered manually. Three of these columns now take 2 or 3 seconds to move to the next cell when the data is entered. Have I accidentally changed something in excel that I don't know about? Cheers Strummer |
Strummer (8836) | ||
| 557091 | 2007-06-08 05:14:00 | This problem has just started recently. I have a few columns that are conditonally formatted so the cell colour will changed to one of two colours when certain data is entered manually. Three of these columns now take 2 or 3 seconds to move to the next cell when the data is entered. Have I accidentally changed something in excel that I don't know about? Cheers Strummer When putting in the conditional formatting, did you select the whole column in each case?( e.g A1 down to A65566) That will slow it down considerably, as it will be trying to recalc each cell everytime you change one. |
the_bogan (9949) | ||
| 557092 | 2007-06-08 05:30:00 | No, it's formatted down to about row 1500. There is a column further along from the problem ones and it works fine. | Strummer (8836) | ||
| 557093 | 2007-06-08 05:42:00 | So the other cells move along fine? Sorry, I didn't really read your original question right. Is your PC/ram struggling with anything else? |
the_bogan (9949) | ||
| 557094 | 2007-06-09 00:24:00 | Okay the problem seems to be with linked data that I've added to the spreadsheet. I made a copy of the sheet and took out the linked data and it seems to run fine. What I don't understand is why it is effecting those particular columns when they are directly related to the linked data at all. |
Strummer (8836) | ||
| 1 | |||||