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
Bookmarks