Google Blogoscoped


Import Another Google Spreadsheet's Data  (View post)

Ahab [PersonRank 5]

Thursday, August 14, 2008
12 years ago3,507 views

Note the ImportRange can cause a security violation. You can use the function to draw data from one of your spreadsheet not shared with others. However when you share the spreadsheet with the ImportRange imported data, the collaborators/viewers of that sheet get access to data they are not entitled to.

The Google Docs team should enforce a re-evaluation of the ImportRange function whenever someone opens the spreadsheet. Re-evaluation shows the ImportRange function to conform to the sharing rules; when the user is not entitled accessing the imported data it won't show.

Until this has been repaired this the ImportRange data is to be considered unsafe when working with sensitive data

This thread is locked as it's old... but you can create a new thread in the forum. 

Forum home


Blog  |  Forum     more >> Archive | Feed | Google's blogs | About


This site unofficially covers Google™ and more with some rights reserved. Join our forum!