|
-
Feb 5th, 2007, 08:12 AM
#22
Junior Member
Re: Excel File Size
If management is only using the spreadsheet as a report viewer, then you could "flatten" the file by doing all the work from your master file, and only saving the values and colors to the file on citrix.
Then each time you open a data file, you can open the file quickly (because there are not formulas, conditions, etc...), then recreate the formulas and conditions through macros on the master, and all the processing is done locally on your machine. When you have made your adjustments, save the values instead of the formulas, and change the colors of the cells or text to match your conditions, then delete the conditional statements.
You would take a big hit performance wise, but the other users would not.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|