Protecting Special column when importing

flevasseur71406

Hi, I've got a sheet in which I import from an Excel spreadsheet data on a daily base.  In that sheet I have a  column (RYG balls) with a formula to calculate overdue estimates.  But every time that I import the new data, that column is crushed.  I even added it at the far end beyond the imported data parameter.  Is there a way to protect that column from being crushed?

Thanks

Andrée Starå

Hi,

How do you import the information?

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? That would make it easier to help. 

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Mike Wilday

Have you tried just copying and pasting the data - minus the columns that have formulas?

Andrée Starå

Another way could be to import and then move the rows to the main sheet.

Would that work?

Best,

Andrée

Jason

Can you elaborate on what you mean by "column is crushed" ?