Hi, I have an odd problem with no idea how to fix it.

I created a program which searches various worksheets for quantities and copies that part number with quantity, description, and price on to a final quote form, it then totals the quote.

It works great on my computer, just as it should, however when I uploaded it to our Intranet so that everyone can use it, it does not show anything on the quote page after I have it generate the quote. If you click in a cell, it shows the appropriate value in the formula bar and if I click back to a different worksheet and back to the quote worksheet everything shows as it should.

I'm total confused as it works as expected offline. Online everthing is there, it just doesn't show initially until I either highlight the cells or click to a different worksheet first.

Has anyone encountered this before and if so how can I solve it.

Thanks!

Mickie