Solved Excel Table Relationships (1 Viewer)

DoneganF

Registered User.
Local time
Yesterday, 18:02
Joined
Aug 7, 2012
Messages
29
In Excel I have 2 pivot tables & 2 charts. Each pivot & chart set is sourced from one of two different data sources (charges & payments). I've create two other tables which contain the unique data shared by both of these tables (enterprise & financial division). I created all the necessary relationships so that I could add slicers that would control both pivots/charts. The first one worked as expected (enterprise). But I'm getting an error message on the second one (financial division). The message indicates that there are blanks in my list. However, there are 56 entries in the list and no blank rows. I'm attaching my list(excel table) and the error message.
 

Attachments

  • ErrorMsg_ExcelRelationships.pdf
    122 KB · Views: 172

namliam

The Mailman - AWF VIP
Local time
Today, 02:02
Joined
Aug 11, 2003
Messages
11,696
Most likely your excel sheet is showing blaks because the rows below your table has been "touched" dispite it showing 56 entries with values in the sheet, it has "used" 60 or more rows...

Try deleting the surpluss rows in the excel sheet...
 

DoneganF

Registered User.
Local time
Yesterday, 18:02
Joined
Aug 7, 2012
Messages
29
Thanks so much - that did the trick!
 

namliam

The Mailman - AWF VIP
Local time
Today, 02:02
Joined
Aug 11, 2003
Messages
11,696
standard problem, my pleasure to help you.

Can you mark the thread solved?
 

Users who are viewing this thread

Top Bottom