Hi all,
I've written a c# program to generate an excel report for the last 8 years, but suddenly and without explanation in the last week, those files cannot open without the repair dialog loading first. I believe something within the 8.11.20 security patches have affected the vlookup functionality, but I can't find any updated documentation that explains what to do differently.
My vlookup refers to a separate file for it's source, so I'm not sure if that's the cause or if there's another issue going on? Here's what the vlookup looks like. The VLOOKUP references a pricelist excel file for it's source data. The report then takes the price and multiplies by quantities based on budgeting data that we pull from a database:
VLOOKUP(RC1,[PriceList.xlsx]Prices!$A:$H,6,FALSE)
I've also attached what it looks like when I open the affected files. I just can't believe Excel would intentionally reference these files as 'corrupt' when they've been working for years. Any thoughts?
