Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

A file with an extension csv, is it possible to connect it to my workbook and get any updated data occurred at any moment?

user-image
Question added by Ahmed Maher allam , Senior IT Consultant , CBK - G&D - AXIS-olutions
Date Posted: 2015/02/26
Syed Tariq Qamar Ali
by Syed Tariq Qamar Ali , Administration Assistant

Absolutely you can! Just go to Text from Get External Data group. Select Importing data right click and click Refresh to get updated data from that file.

Deleted user
by Deleted user

Yes it would be possible as long as the data is well organised in columns and rolls; it would be the same as linking workbooks.

Atif Tanveer
by Atif Tanveer , Decision Support Specialist , Hamilton Health Science

From Data menu select From Text from Get External Data group. After importing data right click anywhere in data table and click Refresh to get updated data from that file.

Ahmed Maher
by Ahmed Maher , System Administrator & IT Consultant , Axis Solutions (KGL)

Yes, i think it is possible if we linked the files to each other.

More Questions Like This