Excel columns jump on their own

Litvak

New Member
Joined
May 5, 2009
Messages
2
I have three computers (2 with XP and one with W2K) wherein the excel columns will jump around and move me to the end or beginning of the column list. It seems to do this on its own and randomly. Sometimes I can get back to where I was and sometimes not. Sometimes I can go for an hour without this happening and sometimes it happens right away. This phenomenon has made excel all but useless. I do move excel files from one computer to the other all the time so maybe one computer's contamination has spread to the other two. Help?
 

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.
Does this happen with new workbooks before they are saved?
Have you reinstalled excel?
Do you have any files that have not been transferred to other computers that are working OK?
Does it happen on all three PC’s?
Are you on a network?
What tests or observations have you made that would be helpful in identifying the problem?
Do you have virus protection on all three PC’s?

Have you tried copying the data to another workbook with any success in solving the problem on that workbook?

What else can you tell us?
 
Upvote 0
query 1: don't know right now
Query 2: yes
Query 3: not clear to us at this time
query 4: not on desktop, sometimes on IBM laptop, always on lenovo laptop
query 5: yes, on network
query 6: tried go-to, freese-unfreese sometimes they work but phenomeno returns
query 7: all virus protected which is kept up-to-date

Thank y0u so much for your response. It is much appreciated.
 
Upvote 0
Sounds like the labtops are the problem.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:eek:ffice:eek:ffice" /><o:p></o:p>
Do they have enough memory? Excel does funny things when memory is short.
Are other programs running at the same time on the laptops? Maybe taking up memory.
Is the size of your transferred workbooks very large?
Does it work OK with small workbooks?
Can you create new workbooks on the laptops with no problems?
Do you have a tech department on site?
Are you transferring the workbooks over the network? If so try copying them to a desk and manually load to the PC
Do you have other laptops or desktop machines you can use to test with?
<o:p></o:p>
Trying to isolate the problem.
 
Upvote 0

Forum statistics

Threads
1,215,510
Messages
6,125,222
Members
449,216
Latest member
biglake87

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top