[RESOLVED, for the time being] Excel File Size

[Siddharth Rout]

Hi

My job requires me to create new trackers every month. To name a few : Attendance tracker, Payroll Tracker, Quality Tracker etc...

I have been trying to find a workaround but haven't been successful.
Basically there are approx 500 employees in my process so I have to use lots of validation-drop down lists, colors, formulas, tables, charts etc...

The problem is the file size. No matter what i do the file size of an average file is minimum 2 mb!!! the files are on CITRIX so it takes more time to open large files...

I tried using vba where ever possible but the size refuses to reduce....

Unfortunately we have to use excel... I tried convincing the management to use vb as frontend and access to store data but they are not ready for it yet...

Is there any other way I can reduce the file size....

Any help will be appreciated...