Help in connecting data table

[Swati Vishwanathan]

Can anyone explain what this means




How can i avoid circular relationship. The case numbers appear in both tables and occur only once in both tables

 

[NARAYANK991]

Hi ,

Normally this can occur when there are formulae involved in either or both of the columns.

When both the columns are entered data this should not occur.

A circular relationship occurs when Field A in Table A is dependent on Field X in Table X , and you now try to create a relationship where Field X in Table X is dependent on Field A in Table A.

If you are still facing the problem , can you upload your workbook ?

Narayan

 

[Swati Vishwanathan]

Narayan

I tried to remove some data from the file because it was too large and got a new error message that one of the linked table is not working.

I encountered the same issue in the morning but I didn't realize what was the problem. When I try to update data, the file breaks.

Is there anyway I can mail you the file

Regards
Swati

 

[Swati Vishwanathan]

Narayan

Please have a look at the file. On the Survey tab, on the pivot table, I am trying to use three tables:

Calendar table, survey table and case table

The calendar table works well with the other tables. But when I try to use data from survey and case table together it says the link is not fine

I am using case number in survey table and case table to make the connect

Regards
Swati

 

[NARAYANK991]

Hi ,

I am sorry , but I have only Excel 2010 , and I am not able to open the Power Pivot window using your file , since you probably have Excel 2013 or later version , in which you have created the Data Model.

Unless you upload it so that there is compatibility with Excel 2010 , I cannot help. Sorry.

Hopefully someone like Chihiro can help.

Narayan