The tables linked to external sources (Excel, XML, CSV or Google Spreadsheet) are always connected to the source files, so every time you refresh a page, the change will be seen.
There's cache on Google's side, so it may take 10 - 15 minutes for the changes to be seen in the table, while Excel tables are stored in ../wp-content/uploads/YEAR/MONTH/, and that's the file you need to modify in order to see the change.
If you import these tables, they will no longer be connected to the external source, and those tables will be considered manual tables, which you would need to manually modify.
Good evening.
How can I set the autorefresh for xls and google sheet tables? I don't see the option.
Shall I have everytime the xls/google sheet is updated to create a new table and then a new chart?
Thank you.
Hello Matteo
The tables linked to external sources (Excel, XML, CSV or Google Spreadsheet) are always connected to the source files, so every time you refresh a page, the change will be seen.
There's cache on Google's side, so it may take 10 - 15 minutes for the changes to be seen in the table, while Excel tables are stored in ../wp-content/uploads/YEAR/MONTH/, and that's the file you need to modify in order to see the change.
If you import these tables, they will no longer be connected to the external source, and those tables will be considered manual tables, which you would need to manually modify.
Kind Regards,
Aleksandar Vuković
aleksandar.vukovic@tmsproducts.io
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Thank you very much.
You're welcome Matteo
If you have any further questions or issues, please feel free to open a new ticket, and we'll gladly help.
Kind Regards,
Aleksandar Vuković
aleksandar.vukovic@tmsproducts.io
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables