3 ms·
That's not really what I'm talking about. That's back to front, where you're using Excel as the core repository for important stuff. I'm talking about using VBA
by perl4ever 7y ago
That's not really what I'm talking about. That's back to front, where you're using Excel as the core repository for important stuff. I'm talking about using VBA/Office the other way around, to combine and report on stuff that lives in various databases and systems, and thereby prevents what you're talking about.
The kind of alternatives I was questioning are BI reporting solutions - I have especially painful memories of Qlikview, and I just googled the licensing fees and they are insane.
- manishsharan 7y agoFinanacial models need to exist in a central repository where they could be audited or updated. The issue with Excel is that the model is created/managed on desktops and the enterprise has no way of knowing if the model is accurate. We use Tableau and we like being able to centrally manage the model.