Benches Uncategorized

4

Referencing Tables - "Invalid Reference"

apple Verified

Imported from the Apple Support Forums via the Wayback Machine 🔗

I'm trying to reference a cell between two tables on a single sheet. While this works with several tables, it doesn't work with one of them--even when I click on the cell I want to reference.

It will, however, work if I duplicate the table, delete the original, rename the duplicate to the original, and then reference the cell. This carries over until I close Numbers.

Previous references to that table will continue to work as intended, but new references return the error *This formula contains an invalid reference.* I receive this error when referencing the cell by clicking on it, typing the reference in, or copying an existing (and working) reference from the Function field.

Any assistance will be much appreciated.

Thanks!

4 replies

Sign in or join Beachball Help to reply.

  1. 0

    KOENIG Yvan

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Hello

    It would be usefull to give us the spelling of the used formula.

    Yvan KOENIG (from FRANCE dimanche 6 janvier 2008 19:01:6)

  2. 0

    EchoD

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Here is the formula being used.

    =Amarr :: Additional Ships Gem1ni

    The table is
    Amarr, the column is N, header +Additional Ships+, and the row is 3, header
    Gem1ni.

    The original formula was created by pressing
    = and selecting cell N3.

    Message was edited by: EchoD

    Message was edited by: EchoD

  3. 0

    KOENIG Yvan

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    May you enter the Numbers's Preferences window.

    Check that the box entitled: "Use header cell names as references" is really checked.

    I'm afraid that it isn't.

    I will read your reaction tomorrow.

    Yvan KOENIG (from FRANCE dimanche 6 janvier 2008 22:31:10)

  4. 0

    EchoD

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    The box was checked. I turned it off and then back on. Everything seems to be working now.

    Thanks!