A user is getting "too many different cell formats" error. It is a very large model.
1 - Besides cleaning up the excel spreadsheet is there a way to work around this?
2 - Can I tally the amount of format's in the spreadsheet. I know they hit the hard 4000 limit, but would like to make certain changes to see the affect it has on the total.
- Also they mentioned that because of the Style of the worksheet when they do try to change certain formats it reverts after they save and close - can anyone elaborate on this for me.
Thanks - SJMP