Title: Auto Update issue Last modified: August 4, 2018 --- # Auto Update issue * Resolved [matts82](https://wordpress.org/support/users/matts82/) * (@matts82) * [7 years, 9 months ago](https://wordpress.org/support/topic/auto-update-issue-2/) * I have a spreadsheet with 32 different pages that were all set to auto update onto my site but suddenly they are failing and I’m getting dodgy formatting all over the page rather than the content – but no idea why. * Attached is one example but there are multiple others if you just go to the [https://insidebtcc.com/drivers](https://insidebtcc.com/drivers) page and select one. * I have other spreadsheets also autoupdating onto the site and they are all working fine – it’s just this one causing a problem. - This topic was modified 7 years, 9 months ago by [matts82](https://wordpress.org/support/users/matts82/). * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fauto-update-issue-2%2F%3Foutput_format%3Dmd&locale=en_US) to see the link]_ Viewing 15 replies - 1 through 15 (of 15 total) * Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/) * (@tobiasbg) * [7 years, 9 months ago](https://wordpress.org/support/topic/auto-update-issue-2/#post-10560389) * Hi, * thanks for your question, and sorry for the trouble. * It seems that Google is suddenly no longer returning a direct CSV file but an HTML file. * Can you post the exact URLs that you are using for the Auto Import? * Regards, Tobias * Thread Starter [matts82](https://wordpress.org/support/users/matts82/) * (@matts82) * [7 years, 9 months ago](https://wordpress.org/support/topic/auto-update-issue-2/#post-10560418) * Hi Tobias * On the example above its [https://docs.google.com/spreadsheets/d/e/2PACX-1vQgz47KwW82LRjWIqVsNNgFYnGHg4GDjlqCscYxRmrFgy2rQqyfKhM6qdXBlML5zW5LXdLJLbccIcvI/pub?gid=1307983391&single=true&output=csv](https://docs.google.com/spreadsheets/d/e/2PACX-1vQgz47KwW82LRjWIqVsNNgFYnGHg4GDjlqCscYxRmrFgy2rQqyfKhM6qdXBlML5zW5LXdLJLbccIcvI/pub?gid=1307983391&single=true&output=csv) * Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/) * (@tobiasbg) * [7 years, 9 months ago](https://wordpress.org/support/topic/auto-update-issue-2/#post-10560465) * Hi, * ok, that’s returning a CSV file for me, as expected, and as necessary. * For some reason though, Google returns something else to the Auto Import… I’ve actually seen exactly this behavior before, just a few days ago. * Unfortunately, I have no clue why this happens, or why Google is not returning the CSV in that case 🙁 * Can you maybe export the wrongly imported table in TablePress to a CSV file and upload that somewhere? Maybe we can reconstruct the content of that HTML page and maybe find more information on that. * Regards, Tobias * Thread Starter [matts82](https://wordpress.org/support/users/matts82/) * (@matts82) * [7 years, 9 months ago](https://wordpress.org/support/topic/auto-update-issue-2/#post-10560501) * If i manually import the file its fine – its only this sheet for some reason * Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/) * (@tobiasbg) * [7 years, 9 months ago](https://wordpress.org/support/topic/auto-update-issue-2/#post-10560520) * Hi, * yes, that’s what we found in the other case as well. Really strange… * It would be great if you could get the “wrong” import as a CSV export for me. * Regards, Tobias * Thread Starter [matts82](https://wordpress.org/support/users/matts82/) * (@matts82) * [7 years, 9 months ago](https://wordpress.org/support/topic/auto-update-issue-2/#post-10560529) * I’ll have a look when back home * Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/) * (@tobiasbg) * [7 years, 9 months ago](https://wordpress.org/support/topic/auto-update-issue-2/#post-10560684) * Hi, * great! Thanks! * Regards, Tobias * Thread Starter [matts82](https://wordpress.org/support/users/matts82/) * (@matts82) * [7 years, 9 months ago](https://wordpress.org/support/topic/auto-update-issue-2/#post-10562483) * [https://docs.google.com/spreadsheets/d/19IeW3fnmLGoV7VOXx730VrAKbQQelr3HdgRpoStjfpY/edit?usp=sharing](https://docs.google.com/spreadsheets/d/19IeW3fnmLGoV7VOXx730VrAKbQQelr3HdgRpoStjfpY/edit?usp=sharing)– here you go * Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/) * (@tobiasbg) * [7 years, 9 months ago](https://wordpress.org/support/topic/auto-update-issue-2/#post-10562528) * Hi, * thanks. Unfortunately, I can’t really see what’s going on there 🙁 The page’s HTML code doesn’t seem to contain much information, but only JS code through which the content is probably loaded :-/ So, this might be a login page maybe, or some captcha thing by Google to rate limit HTTP requests, maybe… * Regards, Tobias * Thread Starter [matts82](https://wordpress.org/support/users/matts82/) * (@matts82) * [7 years, 9 months ago](https://wordpress.org/support/topic/auto-update-issue-2/#post-10562542) * Ok – I have asked the guy who hosts the site to check for any error codes. I wondered if it might be linked to the fact there are 32 sheets in the google doc that will all try to update at the same time, perhaps if I split the document down it might help? (Can you tell I’m not very technically minded…) * Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/) * (@tobiasbg) * [7 years, 9 months ago](https://wordpress.org/support/topic/auto-update-issue-2/#post-10562634) * Hi, * it might indeed be the fact that multiple sheets are to be imported at the same time. Maybe Google has started to no longer like that and then stops serving the requests… * Regards, Tobias * Thread Starter [matts82](https://wordpress.org/support/users/matts82/) * (@matts82) * [7 years, 9 months ago](https://wordpress.org/support/topic/auto-update-issue-2/#post-10562794) * I’ll try it and see if that is the case – I just know that updating the content this way has proven to be a godsend rather than having to do it all offline and then manually re-add the tables (have to do it that way because of calculations and formulas) * Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/) * (@tobiasbg) * [7 years, 9 months ago](https://wordpress.org/support/topic/auto-update-issue-2/#post-10563139) * Hi, * thanks! I’m really sorry that I could not yet help here much 🙁 * Regards, Tobias * Thread Starter [matts82](https://wordpress.org/support/users/matts82/) * (@matts82) * [7 years, 9 months ago](https://wordpress.org/support/topic/auto-update-issue-2/#post-10567897) * Have split the large document down to individual spreadsheets there appears to be no issue with the content appearing as it should on the website so that must have been the cause of the problems I was encountering. * Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/) * (@tobiasbg) * [7 years, 9 months ago](https://wordpress.org/support/topic/auto-update-issue-2/#post-10568860) * Hi, * awesome! Good to hear that this workaround helps! * Best wishes, Tobias Viewing 15 replies - 1 through 15 (of 15 total) The topic ‘Auto Update issue’ is closed to new replies. * ![](https://ps.w.org/tablepress/assets/icon.svg?rev=3192944) * [TablePress - Tables in WordPress made easy](https://wordpress.org/plugins/tablepress/) * [Frequently Asked Questions](https://wordpress.org/plugins/tablepress/#faq) * [Support Threads](https://wordpress.org/support/plugin/tablepress/) * [Active Topics](https://wordpress.org/support/plugin/tablepress/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/tablepress/unresolved/) * [Reviews](https://wordpress.org/support/plugin/tablepress/reviews/) * 15 replies * 2 participants * Last reply from: [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/) * Last activity: [7 years, 9 months ago](https://wordpress.org/support/topic/auto-update-issue-2/#post-10568860) * Status: resolved