Restrict Users

By ask_anurag ·

I would like to know is there any way we can restrict users not to open 100 MB files in Excel.

I want to restrict my users that they can open files only between 20-70 MB files in Excel.

Thanks and Regards,


This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

Some Options

by Toivo Talikka In reply to Restrict Users

You could perhaps write some VBA code which replaces the Open command and checks the file size in the code.

The other option is perhaps writing an application which runs overnight and scans through all the folders your users have access to and reports all .xls files larger than 70MB.

By the way, 70MB sounds like a huge spreadsheet file. Are you sure Excel is the right tool for what your users are doing?

Related Discussions

Related Forums