grizlE

I'm not sure I chose the right location of the forum for this post, but here I go. I want to post an Excel Spread Sheet using Pivot Tables to our Intranet. The Pivot Table is accessing data from an external data base. When I am in Excel it works fine. I noticed I can save the spread sheet as a web page, but I lose the ability of the Pivot Table to be interactive. I am curious if there is a way keep the interactive ability of the spread sheet via VB so I can post it as a web page? I tried simply opening the spread sheet in Internet Explorer, but they might as well just open it in Excel if opened that way. There are also security issues involved with doing it that route. For example: Advanced users could access literally all of files in the data base if they wanted. If they had any idea of how to use or create a DSN. Thus giving them access to data they should not have access to. Any ideas would help.

Derek Stone

I'm gonna give a go at this considering you're not getting much help.
Two suggestions that both require ASP or PHP:

1. Access database directly and simulate Excel environment using HTML form's

2. Create an Excel object on the server (through an OCX executed server side upon request) and proceed to save the Excel data to a webpage that the user is directed to

Hope this sparks some ideas.

Good Luck
-cl