Edit affects same shell in different worksheet

codekiln

New Member
Joined
Aug 29, 2011
Messages
1
Sometimes, when I enter information into a cell, say, h264 on sheet1, the information will overwrite h264 in sheet2 and sheet3. This has happened to me on two previous projects, and it has started happening on this project as well. It happens even when I restart excel and open up the same sheet. Has this happened to anyone else? Is it a known excel bug? It only seems to happen on especially large projects.

My current project is fairly large, but my computer should be able to have it. My worksheet is 7,642 kb and has 15 tabs. I have auto-calculate disabled as I have lots of lookups generating properties for a complex mail merge. I am running Windows 7 Enterprise, and Excel 2010 version 14.0.5128.5000 (32-bit). I have a 64-bit Intel Core i5 CPU 650 running at 3.2 GHz and 3.19 GHz, and 4.2 GB RAM.

Any idea what the problem is?
 

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.
It sounds like you have grouped the sheets. Try clicking on the tab of the sheet that you want to edit to ungroup them.
 
Upvote 0

Forum statistics

Threads
1,223,901
Messages
6,175,277
Members
452,629
Latest member
SahilPolekar

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