tweedledum
New Member
- Joined
- Feb 13, 2009
- Messages
- 8
Hi
I have an excel workbook with a pivot table which displays data from a database. I was tasked with putting this excel workbook up on our company intranet as a mhtml file. This has already been done with another book by he who created the intranet but he isnt around anymore.
I know what you are saying mhtml format does not support pivot tables and formulas etc anymore. Which is why i have to use excel 2002.
I have the excel workbook (which someone else made), i have changed all the database data connections to web queries. the web queries draw the information from the database (which works fine), all the other information are calculations based data brought from the database which is fine. The idea (which worked for the other guy) is to save this as a mhtml file, then change the extension to xls so it opens in excel(which works fine too ). My problem is i need to keep the pivot table, and the formulas that are used where they are, just get rid of the values. I need them to be blank (or 0.00 even its financial data) because its essentially a template, i dont want it to actually calculate all the values until the first refresh when its opened. I have it on good authority that it wont work otherwise. I've tried to actually delete the values but i get the "Cannot change this part of a pivottable report" message, is there any other way of doing this? If you leave it in then the values get added as part of the mhtml in think, for the same reason i delete the database data contained on the other sheet and just keep the web query. I know this is an unusual question but i am sure ye will find it interesting Thanks in advance
I have an excel workbook with a pivot table which displays data from a database. I was tasked with putting this excel workbook up on our company intranet as a mhtml file. This has already been done with another book by he who created the intranet but he isnt around anymore.
I know what you are saying mhtml format does not support pivot tables and formulas etc anymore. Which is why i have to use excel 2002.
I have the excel workbook (which someone else made), i have changed all the database data connections to web queries. the web queries draw the information from the database (which works fine), all the other information are calculations based data brought from the database which is fine. The idea (which worked for the other guy) is to save this as a mhtml file, then change the extension to xls so it opens in excel(which works fine too ). My problem is i need to keep the pivot table, and the formulas that are used where they are, just get rid of the values. I need them to be blank (or 0.00 even its financial data) because its essentially a template, i dont want it to actually calculate all the values until the first refresh when its opened. I have it on good authority that it wont work otherwise. I've tried to actually delete the values but i get the "Cannot change this part of a pivottable report" message, is there any other way of doing this? If you leave it in then the values get added as part of the mhtml in think, for the same reason i delete the database data contained on the other sheet and just keep the web query. I know this is an unusual question but i am sure ye will find it interesting Thanks in advance