2003 Excel my data was duplicated in document

February 13, 2011 at 12:45:00
Specs: Windows 7
I have created a document with about 6 columns. All of a sudden, those same columns were duplicated on the same row, with the same idential columns (with the same alphabetic letters) to the right of the columns I created. So, I have 2 ' sets of A 'B' 'C" etc. on the same lines with my original work.

So, it looks like this:
Betty Jones 888 Daylight Dr. Ona OH 941-888-4444 Betty Jones 888 Daylight Dr., Ona etc...

When I try to delete any of the 2nd group of data, it deletes my original data too!

I have no idea how this happened. So, instead of having 20 pages of data, I have 40 pages of data.

I need to get rid of the duplicate set of data.

See More: 2003 Excel my data was duplicated in document

February 13, 2011 at 12:47:54
The suggestions you have provided do not fit my problem.

Please consider my questions

Report •

February 13, 2011 at 15:19:49
Try running a Diagnostic:

Running Microsoft Office Diagnostics from within Excel/Word

Click the Microsoft Office button
Click on the Excel/Word Options button to bring up the Excel Options dialog box (at the bottom of window)
Click on the Resources button in the left hand pane
Click on the Diagnose button in the right hand pane
Click Continue
Click Run Diagnostics

Running Microsoft Office Diagnostics from the Start Menu

Click on the Start button
Click All Programs
Click Microsoft Office folder
Click Microsoft Office Tools
Click Microsoft Office Diagnostics
Click Continue
Click Run Diagnostics



Report •

February 13, 2011 at 19:37:57
Other than the printing issue, it sounds like you have Compare Side-By-Side activated.

Do the titles of one of the panes end with :1 and the other with :2?

e.g. Book1.xls:1 and Book1.xls:2

However, I've never seen that cause both "windows" to print out since only one is usually active at once. i.e. One title bar is dark blue, the other is light blue.

BTW..how does 6 columns by 50 rows end up up being 20 pages?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

Related Solutions

February 15, 2011 at 10:50:40

Thank you for answering so quickly. I tried doing the diagnostics in Excel first, but I couldn't find the Excel options dialog box. The bottom of my window didn't have anything...that is, if I was in the right place, but my Excel opens up to a worksheet.

Secondly I used the Start Menu. That was fine until I got to the Office Diagnostics and it wasn't listed as an option to click on.

I have a 2003 Version of Office, so maybe that is my problem. I appreciate you trying to help. This is the first time I have ever tried to get help that I got an answer!

Report •

February 15, 2011 at 12:00:47
I have a 2003 Version of Office

2003 does not have Diagnostics.

Try a Detect & Repair

On the Task Bar
Select HELP
Select Detect & Repair

EDIT: You may need the original install media...

I take it that DerbyDad's suggestion of Compare Side-by-Side is not the culprit?



Report •

February 16, 2011 at 09:01:19
DerbyDad03, I just tried your compare side by side, and it isn't highlighted so I can't click on it. I'm assuming that's because the darned 2nd document (same as the first), is already attached in my original workbook.

Got any other ideas?

As far as the number of columns and pages, that was just an example. I have several columns and I'm not really sure how many pages my original document has ended up being. I know it has been like this for sometime. Originally I didn't see that other set of data, so when I printed it out the first time, it said 1 of 58 or something, and yet I knew my document only had about 20 pages. It just kept printing until I finally realized it was printing the same thing again.

So I had to just tell the printer to print only that many pages I wanted. But, of course I still got that 1 of 58 on all pages. I guess I didn't even clear that out yet when I think about it.

Thanks for trying to help. I hope you experts can put your thinking caps on and come up with a solution. I'm going to be using this list for several years and I hate to have to struggle with it each time I work with it.

Report •

Report •

Ask Question