Google Spreashsheet Widget - "There was an error accessing your spreadsheet data. Please ensure a valid range."

  • 1
  • Problem
  • Updated 2 years ago
  • Solved
  • (Edited)
Archived and Closed

This conversation is no longer open for comments or replies and is no longer visible to community members.

Hi Team, just today I was asked to remove an item from our back-end spreadsheet which feeds all the SpreadSheet widgets (the new version) on our presentation.

For some reason, all my widgets are complaining about:  "There was an error accessing your spreadsheet data. Please ensure a valid range."  The widget that was point to the range I removed a column from shows no data at all.  The other widgets, while they also show the same error message, continue to function.

I have double-checked that the ranges are valid.  Can't work out what's up.  Attached are some screenshots showing that everything should be good:

Screenshot 1  here you can see that the widget is referencing the correct spreadsheet, workbook and range.





Any Ideas?
Photo of Kevin Till

Kevin Till

  • 928 Points 500 badge 2x thumb

Posted 2 years ago

  • 1
Photo of Kevin Till

Kevin Till

  • 928 Points 500 badge 2x thumb
This appears to be auto-magically resolved.  I imagine it was related to the Amazon AWS shenanigans the other day.  Thanks for a great product!