Share via

Pivot table with relative references

Anonymous
2013-05-11T14:59:58+00:00

I'm trying to build a project with pivot tables using relative sources. The common practice on the PC does not seem to work on the Mac. When you use an OFFSET formula to refer to a dynamic range, give it a name and try to refer to it the Pivot Table builder says "The command requires at least two sources of data". Has anyone else seen this?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2013-05-12T10:17:57+00:00

    This seems to work on my Mac machine, does it work if you do not insert a pivot table???/

    Create a test Excel file and then try to use the Offset and refer to a dynamic range...

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2013-05-12T15:45:35+00:00

    This seems to work on my Mac machine, does it work if you do not insert a pivot table???/

    Create a test Excel file and then try to use the Offset and refer to a dynamic range...

    I got it to work, but the offset formula cannot refer to a cell variable. My memory is this was possible on the pc side of excel. Since this does not work I have to build distinct names for each table as opposed to one name which is dynamic.

    Was this answer helpful?

    0 comments