Looking for a quick alternative solution to sharing individual sheets like Google Spreadsheets's import range function
Hi. First, I want to comment that I greatly enjoyed using Zoho sheet last year and this spring. As a middle school teacher who loves excel for managing grades, Zoho sheet was a valuable product for me as it allowed me to output grades to individual students and help them to keep track of their progress. However, since the update,
I am no longer able to share individual sheets with others, making Zoho spreadsheet now useless for my own needs. But I like Zoho and would like to say with Zoho. I understand also (from reading other posts) that Zoho is the process of fixing this issue in the next update. However, as a teacher I cannot wait until then. In the meantime, I am wondering if there may be another alternative solution. For instance,
Google Spreadsheets has an import range function where you can import any selected range of data from the one worksheet of one workbook to other books separately. And the importing is
constantly updated every 30 seconds or so, automatically. Thus, instead of making individual sheets for each of my student users, I could make individual workbooks along with a master workbook where the individual workbooks for the students automatically with constant updates receive the data from the master.
Does Zoho have something like this? If not, is there some other solution that might allow me to send separate amounts of data to my students (ie. users). Perhaps a macro or maybe converting the data from a master sheet to a csv uploaded file to be regularly accessed and its data imported by other zoho sheets? (so far I have no luck with doing any such) Please help. Again, I would like to stay with Zoho (as I am sure an number of others who have the same issue would). But if I cannot find a solution, I will not have any choice but to switch to another company like Google Spreadsheets. Thanks again for any help anyone can offer!
Dennis