Excel saving pivot table and data as html files
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. |
Excel saving pivot table and data as 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... |
All times are GMT +1. The time now is 06:51 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com