Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sheet slow moving from cell to cell
I use a spreadsheet for work for expenses. Somehow, a setting in my Excel
2003 must have changed. When I tab from a cell after filling it in, it can take as long as 10 seconds to move to the next next cell. Going through empty cells has no delay. using the same speardsheet on a different computer has no delays at all. Other users of the same sheet have no delays in functionality. An older version of the sheet works fine as well. There must be a setting that I have accidentally chnaged that is doing this, but have no idea which one. I have changed the calculation settign to manual, then bakc to automatic and also automatic except tables, no affect on this issue. The computer has 2gb RMA, running XP Pro SP2, Excel 2003 wiht latest updates. Any ideas what I can check? Thanks, Jeff |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sheet slow moving from cell to cell
JeffLV wrote:
I use a spreadsheet for work for expenses. Somehow, a setting in my Excel 2003 must have changed. When I tab from a cell after filling it in, it can take as long as 10 seconds to move to the next next cell. Going through empty cells has no delay. using the same speardsheet on a different computer has no delays at all. Other users of the same sheet have no delays in functionality. An older version of the sheet works fine as well. There must be a setting that I have accidentally chnaged that is doing this, but have no idea which one. I have changed the calculation settign to manual, then bakc to automatic and also automatic except tables, no affect on this issue. The computer has 2gb RMA, running XP Pro SP2, Excel 2003 wiht latest updates. Any ideas what I can check? Thanks, Hi Jeff, Just a thought ... IME showing page breaks slows down a worksheet, and this is a per-workstation setting. Tools | Options | View | Window options | Page breaks -- uncheck. Problem as it seems, once a worksheet gets the idea that page breaks need to be shown, I need to uncheck the setting frequently. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sheet slow moving from cell to cell
I took a look at that and it is already unchecked. It more looks like the
issue is somehow related to the default printer driver. I recently changed over another computer to Vista and I use the printer connected to the Viusta machine. I had to replace my printer wiht another one because there was no Vista driver for it (HP Laserjet3100), so now I have an HP Officejet 6100. It may be an issue with the actual driver, since the issue exists even when not conected to the home network with. The same spreadsheet on the Vista machine works fine, so it appears to be something odd in the driver for the printer. Now all I need to do is figure out how to resolve this and keep the default printer setting. Jeff "smartin" wrote: JeffLV wrote: I use a spreadsheet for work for expenses. Somehow, a setting in my Excel 2003 must have changed. When I tab from a cell after filling it in, it can take as long as 10 seconds to move to the next next cell. Going through empty cells has no delay. using the same speardsheet on a different computer has no delays at all. Other users of the same sheet have no delays in functionality. An older version of the sheet works fine as well. There must be a setting that I have accidentally chnaged that is doing this, but have no idea which one. I have changed the calculation settign to manual, then bakc to automatic and also automatic except tables, no affect on this issue. The computer has 2gb RMA, running XP Pro SP2, Excel 2003 wiht latest updates. Any ideas what I can check? Thanks, Hi Jeff, Just a thought ... IME showing page breaks slows down a worksheet, and this is a per-workstation setting. Tools | Options | View | Window options | Page breaks -- uncheck. Problem as it seems, once a worksheet gets the idea that page breaks need to be shown, I need to uncheck the setting frequently. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Arrow keys move screen instead of moving from cell to cell | Excel Discussion (Misc queries) | |||
Force user to enter data in cell before moving to next cell | New Users to Excel | |||
Slow Moving From Cell to Cell | Excel Discussion (Misc queries) | |||
Moving rows from one sheet to another based on a particular cell v | Excel Discussion (Misc queries) | |||
Moving from cell to cell is very slow!! | Excel Discussion (Misc queries) |