1

I am writing a Python program to extract values from a google sheet and I am running into a weird problem whereby named ranges that I know I have put in to the sheet starts disappearing. When I re-enter them, some other range disappears. This has happened after I have added a large number of named ranges. I don't get any error message and it is seems somewhat random which ranges disappears. Could it be that there is a maximum number of named ranges and that some old ranges are removed automatically when I add a new one? I have search for any maximum number in the documentation but haven't been able to find one.

NiklasR
  • 473
  • 6
  • 19

1 Answers1

1

Yes, there is. Currently nine hundred and ninety nine (999).

'Suck it and see' courtesy Jacob Jan Tuinstra.

pnuts
  • 58,317
  • 11
  • 87
  • 139