Hello,

I am cathering data with ODBC and vlookup to single excel sheet. Same sheet also have two colums, where users are able to add comments etc. After user clicks "Update All", the data from those comment cells jumps to different row. Is it even supported to allow user editing in this kind of sheet? Help would be appreciated.

Hi VilleA,

Is this application developed by yourself? And you said those comment jumped to different row, I wonder to know whats the meaning of jump to different row? If the data updates to the users application and not match to the correct row in users computer, or if the user updates the wrong data (update the different row) from data sources?

 If possible could you take a screenshot and upload it, and could you be at bit more precise explain your problem so that we can get more accurate solutions to this problem. I am glad to help and forward to your reply.

Regards,

Emi

• Edited by guGuuuMy 22 hours 9 minutes ago

Hi Emi,

Thank you for your answer, and sorry for stating my problem unclearly.

So, now I'm trying to make more sence.. I have created analysis report in Excel, and I am cathering data from ERP database (ODBC) and from other sheets (VLOOKUP). I have also some calculated fields. Same sheet also has two colums where user is able to add comments and customer information etc. When user clicks 'update all' in excel, so all the data from the database and other sheets gets refreshed, all the contents from comment cell jumps to different cell, for example from R3 to R3000. The row postitioning disappears. It has something to do with sorting, but I haven't figured it out, so I'm stuck.

I will add screenshots after I am able to verify my account.

Does this make sence at all? Any help would be appreciated.

Regards,

Ville