I think you may slightly misunderstand the functionality, it's an updateable link to some other file (which is, frankly, great). I can import a CSV file I generate with code ONCE, build up a huge calculation from it (probably in other sheets), and then the next day, regenerate the CSV, update the link WITHIN EXCEL, and boom, all of my computation is redone.
Very underutilized feature, but incredibly useful when using Excel not as a CSV viewer (if you want that, you can buy that elsewhere) but as a critical part of running a business.
Excel exists to make it almost free to write accounting-like software. It does NOT exist to view CSV files.
Comments
I think you may slightly misunderstand the functionality, it's an updateable link to some other file (which is, frankly, great). I can import a CSV file I generate with code ONCE, build up a huge calculation from it (probably in other sheets), and then the next day, regenerate the CSV, update the link WITHIN EXCEL, and boom, all of my computation is redone.
Very underutilized feature, but incredibly useful when using Excel not as a CSV viewer (if you want that, you can buy that elsewhere) but as a critical part of running a business.
Excel exists to make it almost free to write accounting-like software. It does NOT exist to view CSV files.