About 2 weeks ago my pivot tables started displaying a blank sheet rather than weekly and monthly totals from my Jobs. Did something change with AppSheet or Google Sheets about 2 weeks ago? Fix? Please see the screenshots.
@Mark_Cobb It appears that Google may have changed something with the way that pivot tables are generated, which is causing some problems with AppSheet. See the solution described in this thread: plus.google.com - Google Sheets bug โ โinternal server errorโ A few users have reported thatโฆ Google Sheets bug โ โinternal server errorโ A few users have reported thatโฆ plus.google.com
@tony I saw that initially but dismissed it because the pivot table issue started about 2 weeks ago. Nevertheless I will try re-creating the pivot tables and report back.
@tony I finally got around to re-creating a pivot table. Itโs still showing a blank table when selecting my PT menu item. However I learned a few things that may help figure out what the problem isโฆ
When initially adding the new pivot table to Data > Tables I would get โCould not read worksheet because the table is emptyโ. Once I added header columns above the pivot table, all errors went away - however it still shows blank in my app. Youโll notice in the screenshot that the PT uses bold and italics formatting for the header rows (Mo & Tot), however the formatting cannot be removed. As mentioned in the other thread, I wonder if the PT text formatting is causing my problem?
AppName is CTJobs1-109217 if you want/can look at it.
@Mark_Cobb It looks like youโve got two header rows. Can you use just one and see if that helps?
@tony The other PT sheets have one or no header - and theyโre blank as well.
User | Count |
---|---|
61 | |
25 | |
14 | |
11 | |
6 |