Good morning,
I have a sales mix model which essentially lists restaurant dishes by category by volume. A couple of tables and half a dozen charts run off this data. There are no external links. The workbook is around 500kb
For a second brand of restaurants I have an identical model, again no external links. The raw data that feeds to sales mix page is identical (copy and paste) from same source, all the formulas are the same,... yet this workbook is 5,888kb?!?
As a result it is painfully slow. But I can't find any differences for between the sheets. There is no more data on the second model than the first, no more formulae,.....
Does anyone have an idea what would cause this?
Many thanks
Ben
I have a sales mix model which essentially lists restaurant dishes by category by volume. A couple of tables and half a dozen charts run off this data. There are no external links. The workbook is around 500kb
For a second brand of restaurants I have an identical model, again no external links. The raw data that feeds to sales mix page is identical (copy and paste) from same source, all the formulas are the same,... yet this workbook is 5,888kb?!?
As a result it is painfully slow. But I can't find any differences for between the sheets. There is no more data on the second model than the first, no more formulae,.....
Does anyone have an idea what would cause this?
Many thanks
Ben