strange problem in Excel 2004

Discussion in 'Mac Apps and Mac App Store' started by buckuxc, Nov 7, 2005.

  1. buckuxc macrumors regular

    Aug 28, 2003
    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?

  2. iSaint macrumors 603


    May 26, 2004
    South Mississippi y'all, near the water!
    See if sheet two's info is linked to sheet one. Or, make sure you are pasting the information and not the links/formulas.
  3. dragula53 macrumors regular

    Jun 23, 2003

    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.
  4. buckuxc thread starter macrumors regular

    Aug 28, 2003
    As far as I know, it's just raw'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.


Share This Page