Why are google spreadsheet images not loading?

Question

Images

Hello! I made a file with several tabs in Google spreadsheets, a catalog of images, photos are loaded via the IMAGE function from my Google drive, where they are all stored. Photos are stretched to the entire cell, an example of the function is =image(" drive.google.com/uc?export=view&id=1plkTGOqEBIugL8... ";2)
The fact is that when you enter the table, not all images are loaded, but only part, when updating, some are selectively loaded, others are not loaded, in short, how lucky. How can I speed up the upload process (about 300 photos are planned, if a part is stupid it’s bad, since the table will be viewed by other people on the Internet via a shared link. I experimented with browsers - I opened it in chrome, the explorer, the same thing, the Internet is normal (GPON in Moscow Who knows) Trouble Google?

Answer 1

Most likely not.
You can, of course, try to check with a script so that all the pictures are loaded as they should, but there will be no benefit from this. You are asking Tableau to make 300 requests per refresh of your browser. This is too much at the moment for any system. Try changing the Table so that no more than 50 images are loaded per sheet. For example, split the catalog into chunks of 50 items, or add a filter or formula.