Excel 2003 pivot table

G

Guest

I have the data source and a pivot table on 1 sheet of a workbook. When I
saved the file, I noticed in the folder that a separate folder was created
which contains HTML files, a cachedata xml and a filelist xml document and a
stylesheet document. When I email the original .xls file the user can't open
it. The error states 'Problem During Load" and then lists the HTML files are
missing.
 
N

Nick Hodge

Diane

When you go to save it, make sure when you select File>Save as... That the
'File of Type' is set to 'Excel Workbook'. It sounds like you are saving as
a web page

--

HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
web: www.nickhodge.co.uk
blog (non tech): www.nickhodge.co.uk/blog
 
G

Guest

Nick
You were right. I just assumed the default save was a Workbook, I usually
don't look at the type.
Thanks ;-)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

xslt and .net 1
Excel 2007 Pivot Table Disappears 1
2nd Pivot Table on Worksheet Crahes Excel 1
How do I locate overlapping pivot table reports in Excel 2003? 1
Pivot table filter list - listing irrelevant subcategorys 1
Export Pivot table 1
How do I transform this xml file into html by using this xslt document 9
Excel 97 Pivot Table not compatible with Excel 2003 1

Top