I've tried "Sobolsoft's Excel Find and Replace" software, but that doesn't seem to want to look inside formulas to replace. What I need to do, is perform a find and replace on ~300 workbooks, find the CSV server path inside the formulas and replace it with the new server path for the. xsl file which excel doesn't have any issues referencing. In all my research I've found there doesn't seem to be a way to fix this other than replace the datasource with a. My issue is that excel treats the CSV data dump as "dirty data" and prompts warnings every time a workbook is opened claiming it can't update the links(But when the links are checked, excel then says there's no issue). I have a directory with 6 sub-folders and ~300 excel workbooks(Growing every day).Įach workbook has multiple formulas (~1200 per workbook) that reference a CSV data dump stored on a server path.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |