I have a user who is exporting data from a website into excel files.

When he creates a pivot table from this excel file it creates another
folder in the same directory of the excel file containing html files.
If you delete this folder and reopen the original excel file all the
data is gone. For some reason it is exporting all the data into these
html files.

Any suggestions for stopping this from occurring? The only thing I
could find so far is when I go into the properties and Summary tab I
see this in the Hyperlink Base box: http://blablabla.cgi blablabla
being an internal site.

I tried clearing that out and doing the pivot table again, but it
still created the html files.

Well, I don't know how I missed it, but just doing a save as showed it
was saved as an excel file, but in html format...
So I just changed it back to xls format...