Formatting web imported data and refresh
Hi all,
I am creating an Excel database. I would like to import names, emails and job positions of all employees of a private company from the firm website.
I chose Data->From Web and selected the whole page, as only one yellow icon to select data was available. In fact no table for the above data is present: just a quite big webpage with photos of employees and names, emails, job positions next to them.
I imported the data into my Excel spreadsheet and I began to change their format, by moving email accounts in the "email" column and similarly for job positions and names. I deleted the photos.
I would like to refresh data keeping this new format. Unfortunately, every time I refresh the imported data using the "refresh all" button, they return to the original format, which is quite bad.
How can I keep the new format for my imported data and refresh them without returning to the original one?
I thank you all for your support!
Kr,
Infogeo
Change properties of imported data
Right-mouse click on your imported dataset, choose "Data Ranga Properties", check box "Preserve Cell Formatting".