How to link all tables created using csv macro ?

[Priya Ramakrishnan]

HI...

I have a .csv file which has tables. I wanted to create charts by using the tables. Instead of copying and pasting the table for each chart..I used CSV macro ...where the required csv can be uploaded and the macro uses the table and plots charts...

The thing is if i have 10 charts in a page..I had to copy paste the Attached CSV macro ten times...

Is there any way like ...I can upload the CSV in one section of the page and the same can be linked to those ten places...Like Table excerpt and Table excerpt include?

[Katerina Kovriga _Stiltsoft_ · Accepted solution]

Hi @Priya Ramakrishnan ,

You've answered the question yourself - wrap the CSV macro in the Table Excerpt macro and reuse the table with the help of the Table Excerpt Include macro.

Thereby you'll need to attach your CSV file only once, but will be able to make as many charts and pivots as you want.

[Priya Ramakrishnan]

Thanks!!..it worked