0

Clearing Data Problem

Hi Guys,

I have a strange problem on a report where when the report runs the very first time from opening excel it is fine, thereafter if you try and change the company the report gets stuck at a certain cell.

I have obviously checked that cell and there is nothing peculiar there and have even deleted the reference only to see that the report will still get stuck at the next formula. Either way, the report does work as it always runs perfectly the very first time.

The only way I can get it to run a second or consecutive time is to cancel it while it is stuck, take it back to designer and it still also gets stuck here, so i have to cancel again and then i can change the company and run the report.

To me it seems as if it is not clearing some data somewhere in between changing the filter options?

Any suggestions?

I am using excel 2003 and Jet Version 7.1.2 1830

3 comments

Please sign in to leave a comment.