Forum Discussion
unable to disable/delete embedded Web Query links in excel - screen shots added
I have created a worksheet using "web select" to input data from financial statements online. This is supposed to save me time and effort of manually typing in and proofreading thousands of lines o...
I import financial data (personal, not work or business related) all the time, but I do it by first exporting the data from the financial institutions, all of which make that fairly easy to do. Some do it via Excel files, most (really, all) offer to export CSV files (which in at least one case--I'm looking at you, American Express--is far to be preferred to their abomination of an XLSX file).
So depending on what it would take to start over, instead of cleaning up what you already have, I'd recommend investigating that export-then-import route.