Hi ,

I have a sheet which is having data connection with .iqy file.

Share point contains the columns Name and Address. Rank column is inserted manually and users will be entering values in that column to the respective name.

notUpdated.jpg

When a new row in inserted while refreshing the Data connection, existing Rank value is not moved down along with the respective row.

AfterRefresh.jpg

Please help me out resolving this.

Thanks,
Viney