I have published a excel file to a web site. In the Open function for the workbook, I put in code to read a file and store a value in a cell on the worksheet. It appears that the open function only works the first time I open the sheet on the web site. I thought I had the code working on Tuesday, but when I tried it again on Wednesday, it looks like it is not running the open function again.

If I re-publish, it runs the code only once and then just show what was there before.

Any ideas on what is going wrong?