Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 915
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Arrow keys move screen instead of moving from cell to cell LuisGe Excel Discussion (Misc queries) 3 May 22nd 09 11:17 PM
Force user to enter data in cell before moving to next cell Fusionmags New Users to Excel 3 November 19th 06 11:49 PM
Slow Moving From Cell to Cell rlaf Excel Discussion (Misc queries) 2 April 21st 06 07:13 PM
Moving rows from one sheet to another based on a particular cell v mm Excel Discussion (Misc queries) 0 November 11th 05 06:29 PM
Moving from cell to cell is very slow!! Skoal Excel Discussion (Misc queries) 4 April 7th 05 09:49 PM


All times are GMT +1. The time now is 12:24 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"