ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Sheet slow moving from cell to cell (https://www.excelbanter.com/excel-discussion-misc-queries/199986-sheet-slow-moving-cell-cell.html)

JeffLV

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

smartin

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.

JeffLV

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.



All times are GMT +1. The time now is 08:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com