Excel Microsoft Excel 2007 Problem

[totalvita]

Hi everybody. I have a bit of a problem with Microsoft Excel 2007 and its files.

There a the file name "Y." However "Y" is a 696 kb file, which means it has an amount of information within it. But however whenever opened it has an error of: Excel found unreadable content in 'Y.' Do you want to recover the contents of this workbook? If you trust the source of this workbook, click Yes.

So I click Yes, but however information from an other Excel File: "X" shows up.

Is there a reason for this? How can I fix it?
Thank you very much.

 

[Stoneboysteve]

totalvita,

Sounds like file 'Y" is using file "X" for an external data source. Look at the formulas in "Y" and see if it is looking at "X".

Hold down crtl and tilde to toggle the formula view.

Stoneboysteve

 

[totalvita]

It appears the formulas are relatively the same, but the layout is different. The worksheets of "Y" is equivalent of "X."