3 ms·
Excel has that functionality, and has had it for a long time. It is used a lot, at least I've seen it used a lot, for internal functions such as workflow MIS (
by zhte415 11y ago
Excel has that functionality, and has had it for a long time. It is used a lot, at least I've seen it used a lot, for internal functions such as workflow MIS (on wall mounted displays no less, that no one knew was Excel as we'd hidden anything Excel-like, like grids and menus / title bars, etc -fantastic to hack a quick solution, for example a visitor was coming, and we'd switch to a one-off sheet "Welcome XXX visitor" for 20 seconds through the day, that hack took 5 minutes, super easy) and general data functions.
As well as connections to conventional databases, SharePoint integration is a big thing - have a little macro that does a refresh (and a second one that mimics the movement of a mouse so the mandatory screensaver doesn't turn on).