Hi

I am having trouble with importing CSV files to a report I have built, when I refresh(import) the csv, formulas change in another sheet with in the Report. The formulas that change reference the imported CSV, problem is some formulas change and others stay the same, it doesn't happen every time.

I notice the formulas at the top of the sheet are ok it is just formulas down the page that change, then below the changed formulas that show a result of #N/A the formula doesn't show this fault but the formula itself has changed to reference much higher in the sheet than it should.

Just wonder if there is anything obvious with importing that I have neglected to do.

Thanks