Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to modify specific records in excel document?

Hi,

I have input boxes that take user input.  I have a macro that sends that input to the next blank row in a specified excel document and then reloads the app to show the data that was saved in that excel sheet.

I have a chart that reads the data from the excel.  I would like to be able to modify the record that the user clicks on, and save it to the excel document thus overwriting the previous values.

Would anyone have any clues on how to do this?

I thought about making an autonumber field and somehow referencing that as a key of sorts...not sure.

2 Replies
Not applicable
Author

Would Dynamic Update work?

Not applicable
Author

Any bites?