Formula does not calculate when data is imported to a sheet (through a macros)

[dsanchez]

Hello guys

I have a sheet (let's call it "customer") with an 'Import' button on it which I use to import a CSV file and load the data from that file in the sheet.

In cell A1, a customer's name is filled in when importing this file.

In another sheet (let's call it "calculator"), I have certain formulas. These formulas use the 'Fuzzy Matching' function (this function is in a VBA module)

http://www.mrexcel.com/forum/excel-q...planation.html

The problem:

When I import the CSV data and the macros fills the the cell A1 with the customer name, the formula in the "calculator" sheet (which needs input from A1) does not work. And it seems it does not work because it does not recognize that there's information present in A1.

If however, I put manually any given customer name in A1 the formulas in the 'calculation' sheet do work.

Can you please advice on what could be wrong here?

Thanks!

[swoop99]

At the the very end of the macro that does the importing, put the following command:

Please Login or Register  to view this content.

[dsanchez]

thanks a lot for the quick answer!

i tried this but the problem persists. is there any other workaround?

thanks!

[dsanchez]

anyone else?

[dsanchez]

bump. anyone?