strange problem in Excel 2004

[buckuxc]

It's been tought figuring out what exactly is going on with this problem, but I think I finally did it...however, I have no clue how to remedy it. The excel file I'm copying from has more than one sheet. I am trying to copy information from individual or multiple cells in a row on sheet 2 into a completely new excel file. But when I paste the information, it's pasting from the first file's sheet 1!!! For example, I'm trying to copy an email from Alum Info.xls, sheet 2 which is in cell 3F. But instead what gets added to the clipboard (apparently) is from sheet 1 cell 3F, which is the word Spain. What is going on here?!?!?! Is this just a bug?

sps

 

[iSaint]

See if sheet two's info is linked to sheet one. Or, make sure you are pasting the information and not the links/formulas.

 

[dragula53]

excel

excel is sometimes too smart for it's own good.

without knowing what kind of data you have in the cells, I can't really tell you if it is a normal behavior or not.

but if the data you are copying is linking to other cells, it is likely trying to deduce what should happen rather than what you want.

if it is just raw data, it is possibly a bug.

edit: yeah, what previous poster said.

 

[buckuxc]

As far as I know, it's just raw data...it's all text. The file is really just an excel sheet being used as a database. Granted, I don't necessarily like using Excel as a database, it's annoying, but it's how my office keeps certain information so that it can be "easily" sent to other offices.

So I think it's just text and it's not trying to figure out a formula.

sps