There a way out for this. You can decide what users can do what they cannot.
Even you can have security implemented on sheet level
For that you need to go through the section access document available at the link below.
Hope that helps
even though this document is very informative, it doesn't have anything as far as controlling the amount of data the users can work with. It looks like l Access is mainly for controlling WHAT data the user can see, not how much data they can bring into the application by creating charts & reports.
Thanks for the link though, I am sure I will need that in the near future.
I guess you are talking about collaboration or shared objects.
If you are using QV9 then you have only 2 option for Shared/Collaboration objects, either give access to create a collaboration objects to all user or restrict for all.
And if you are using QV10, then you can control user wise, to give access to individual for creating shared/collaboration objects through QEMC.
But here also you can not control the data volume.