Two Excel worksheets in the same workbook have become mysteriously linked to each other

%3CLINGO-SUB%20id%3D%22lingo-sub-1588078%22%20slang%3D%22en-US%22%3ETwo%20Excel%20worksheets%20in%20the%20same%20workbook%20have%20become%20mysteriously%20linked%20to%20each%20other%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1588078%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20been%20using%20Excel%20(Office%20365%20subscription)%20for%20less%20than%20six%20months%2C%20so%20consider%20this%20a%20new%20user%20question.%26nbsp%3B%20I%20recently%20added%20a%20second%20sheet%20(Sheet2)%20to%20a%20workbook%20to%20act%20as%20a%20backup%20for%20data%20in%20Sheet1.%26nbsp%3B%20That%20way%2C%20if%20I%20accidentally%20destroyed%20the%20data%20in%20Sheet1%2C%20I%20could%20simply%20copy%20and%20paste%20it%20back%20from%20Sheet2.%26nbsp%3B%20The%20data%20is%20purely%20numeric%20(no%20formulas).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EToday%20I%20needed%20a%20place%20to%20try%20out%20a%20formula%20and%20I%20decided%20to%20use%20sheet2%20as%20a%20scratch%20space.%26nbsp%3B%20%26nbsp%3BI%20began%20typing%20the%20formula%20into%20cell%20M12%20starting%20with%20the%20equals%20sign.%20However%20I%20did%20not%20see%20the%20equals%20sign%20in%20the%20formula%20bar.%26nbsp%3B%20It%20showed%20up%20in%20K48.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20tried%20copying%20and%20pasting%20from%20one%20sheet2%20cell%20to%20another.%26nbsp%3B%20At%20this%20point%20I%20realized%20the%20copy%2Fpaste%20was%20coming%20from%20sheet1%2C%20even%20though%20I%20was%20in%20Sheet2.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20should%20mention%20that%20this%20is%20a%20VBA%20application.%26nbsp%3B%20The%20workbook%20does%20not%20contain%20any%20formulas%2C%20only%20data.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20following%20may%20be%20relevant.%26nbsp%3B%20While%20I%20was%20having%20this%20problem%2C%20I%20noticed%20at%20the%20bottom%20of%20the%20Excel%20window%20that%20the%20tabs%20for%20Sheet1%20and%20Sheet3%20were%20both%20white%20(as%20if%20both%20were%20on%20top).%26nbsp%3B%20After%20clicking%20the%20tabs%2C%20I%20got%20them%20to%20where%20only%20one%20tab%20at%20a%20time%20was%20white.%26nbsp%3B%20But%20the%20problem%20described%20above%20did%20not%20disappear.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20idea%20what%20could%20be%20happening%2C%20and%20what%20I%20might%20have%20done%20to%20cause%20it%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1588078%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1588095%22%20slang%3D%22en-US%22%3ERe%3A%20Two%20Excel%20worksheets%20in%20the%20same%20workbook%20have%20become%20mysteriously%20linked%20to%20each%20other%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1588095%22%20slang%3D%22en-US%22%3E%3CP%3EHere%20is%20what%20I%20see%20at%20the%20bottom%20of%20the%20Excel%20window%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor

I have been using Excel (Office 365 subscription) for less than six months, so consider this a new user question.  I recently added a second sheet (Sheet2) to a workbook to act as a backup for data in Sheet1.  That way, if I accidentally destroyed the data in Sheet1, I could simply copy and paste it back from Sheet2.  The data is purely numeric (no formulas).

 

Today I needed a place to try out a formula and I decided to use sheet2 as a scratch space.   I began typing the formula into cell M12 starting with the equals sign. However I did not see the equals sign in the formula bar.  It showed up in K48.

 

I tried copying and pasting from one sheet2 cell to another.  At this point I realized the copy/paste was coming from sheet1, even though I was in Sheet2.

 

I should mention that this is a VBA application.  The workbook does not contain any formulas, only data.

 

The following may be relevant.  While I was having this problem, I noticed at the bottom of the Excel window that the tabs for Sheet1 and Sheet3 were both white (as if both were on top).  After clicking the tabs, I got them to where only one tab at a time was white.  But the problem described above did not disappear.

 

Any idea what could be happening, and what I might have done to cause it?

1 Reply

Here is what I see at the bottom of the Excel window