Title: Link different worksheets
Last modified: June 20, 2022

---

# Link different worksheets

 *  Resolved [benorange](https://wordpress.org/support/users/benorange/)
 * (@benorange)
 * [3 years, 10 months ago](https://wordpress.org/support/topic/link-different-worksheets/)
 * Hi,
 * We have a requirement to display scores for several subjects over several years
   on our site. Thanks for any help in advance.
 * I want to maintain a master list in the first worksheet on googlesheets with 
   linked worksheets for different categories so the masterlist can be updated and
   the appropriate worksheet will update (subject A, year X, session Z).
 * We want the table on site to load as quickly as possible so would prefer not 
   to wait for data to load that is not required.
 * 1. Can we use this plugin to call a specific worksheet on googlesheets?
 * 2. Can we use this plugin to display a graph inside the worksheet?
 * Bw,
    Ben

Viewing 1 replies (of 1 total)

 *  Plugin Author [wpDataTables](https://wordpress.org/support/users/wpdatatables/)
 * (@wpdatatables)
 * [3 years, 10 months ago](https://wordpress.org/support/topic/link-different-worksheets/#post-15763255)
 * Hello Ben,
 * Thank you for reaching out to us.
 * With the Lite version (which is hosted here) you can only create tables linked
   to existing sources (Excel, Google Spreadsheets, CSV, etc) but those tables load
   the data in its entirety, output the entire table to the front-end all at once,
   and then split it into pages using JavaScript; all processing is done on the 
   client’s computer by JavaScript. This works fine for relatively small tables,
   but if the table gets bigger the page also gets larger. Consequently, page generation
   and load time will also increase and everything will take more time. For larger
   data sets (more than 2.000 – 3.000 rows, and in some cases more than 500 rows),
   these wpDataTables will work slower, and for really large data sets (10.000 rows
   and more) the page can crash completely.
 * If the table is supposed to have more than 2.000 – 3.000 rows, you’d need to 
   use the full version of the plugin and fetch the data using [server-side processing](https://wpdatatables.com/documentation/table-features/server-side-processing/)
   which will fetch only the rows currently displayed on the page, making the page
   load faster.
 * You would be able to fetch a single sheet from Google Spreadsheets, since every
   sheet has its own URL, but depending on the data size, you may want to think 
   about different options for creating tables with wpDataTables.
 * Graphs can be added to the table, either as images by using the  tag, or by enabling“
   Parse shortcodes in strings” and adding the shortcode of an existing wpDataChart
   to the Google Spreadsheet you’re using.
 * Kind regards.

Viewing 1 replies (of 1 total)

The topic ‘Link different worksheets’ is closed to new replies.

 * ![](https://ps.w.org/wpdatatables/assets/icon-128x128.gif?rev=3010404)
 * [wpDataTables - WordPress Data Table, Dynamic Tables & Table Charts Plugin](https://wordpress.org/plugins/wpdatatables/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wpdatatables/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wpdatatables/)
 * [Active Topics](https://wordpress.org/support/plugin/wpdatatables/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wpdatatables/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wpdatatables/reviews/)

## Tags

 * [Google Sheets](https://wordpress.org/support/topic-tag/google-sheets/)

 * 1 reply
 * 2 participants
 * Last reply from: [wpDataTables](https://wordpress.org/support/users/wpdatatables/)
 * Last activity: [3 years, 10 months ago](https://wordpress.org/support/topic/link-different-worksheets/#post-15763255)
 * Status: resolved