We have found that Cube Views and Table Views work really well if there are not too many of them in a workbook. I can't define 'too many' accurately but certainly we had a workbook with over 75 Cube Views which causes a lot of problems. You don't say which version you are on - the later versions (9+) have improved performance for embedded objects in Excel. We looked at using Books - the performance is really good but the format is poor. We wanted more than 1 Cube Views on a single sheet and this is not possible in Books. In summary, we are still using Cube Views as they are easier to manage and update but we have split the workbook into smaller pieces for performance and reliability reasons.
Hi Marcus, thanks so much for sharing this — super helpful insight.
That aligns with what we’re seeing as well. Our issues seem to show up mainly when workbooks grow large and complex, with many embedded objects across multiple tabs. Good call on splitting workbooks into smaller pieces for performance and reliability — that’s something we’re starting to consider more seriously.
We’re currently on version 9+, so it’s good to know performance improvements are there, but design still plays a big role. Also appreciate the perspective on Books — great performance, but the formatting and layout limitations make them harder to use for our needs.
Really helpful context, thank you again for taking the time to respond!
