Update sheet with imported data and manually added rows/columns

noshiro

Hi,

I have a sheet with imported data from excel. I want to add sub rows. When I update the imported data, will the added sub rows delete?

same for added columns. If I add columns to the imported data sheet, will the columns delete?

Harris

I haven't figured out how to avoid that myself, I'll definitely stay on your thread for updates!

Adam Murphy

How are you planning to update the imported data? To my knowledge when you import an excel file a new sheet/grid is created.

noshiro

@Adam Murphy In my existing sheet, I would go to File>Import>Import Microsoft Excel. Then there's an option to "Update Rows"

Adam Murphy

I think this is a feature of data shuttle where you can read from an attached excel spreadsheet and update fields in existing rows. I'd take a look at that.

noshiro

@Adam Murphy I'll definitely take a look at data shuttle. Thank you!