ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Cell automatically copying to multiple sheets. (https://www.excelbanter.com/excel-discussion-misc-queries/193830-cell-automatically-copying-multiple-sheets.html)

Iceman81005

Cell automatically copying to multiple sheets.
 
Excel 2007: I have a spreadsheet with multiple sheets(20), each with similar
account information for 20 individuals. When I start to enter data into one
of the sheets, it is now duplicating this data in the other sheets as well.
As far as I can tell, there is not a macro present, but I am new to 2007, so
I am not sure. Any suggestions or anyone who has had similar issues??

Max

Cell automatically copying to multiple sheets.
 
Just hazarding a guess (based on xl03, I don't have xl07). Maybe all the
sheets are accidentally in grouped mode? Do a right-click on any of the
grouped sheets Ungroup Sheets
--
Max
Singapore
http://savefile.com/projects/236895
Downloads: 15,500, Files: 352, Subscribers: 53
xdemechanik
---
"Iceman81005" wrote:
Excel 2007: I have a spreadsheet with multiple sheets(20), each with similar
account information for 20 individuals. When I start to enter data into one
of the sheets, it is now duplicating this data in the other sheets as well.
As far as I can tell, there is not a macro present, but I am new to 2007, so
I am not sure. Any suggestions or anyone who has had similar issues??



All times are GMT +1. The time now is 10:33 AM.

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