| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel / Sql Server / Pivot Tables
I can connect a Sql Server stored proc to an Excel 2003 pivot table via an
ODBC File DSN, and the pivot table will refresh for anyone in our company who has it, so long as they reside inside our LAN, or they have VPN access to our LAN. Question: Is there a way to connect an Excel pivot table to a Sql Server stored proc (as above), but via a Web Server, so that I can send that .xls file to someone outside our LAN, and that user will still be able to refresh the pivot table from his local machine (as long as he has an internet connection)? Thanks in advance ... Bill |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Building pivot tables in Excel 2007 based on existing pivot tables? | Excel Discussion (Misc queries) | |||
| SQL Server -- Bulk Insert from Excel to SQL Server | Excel Discussion (Misc queries) | |||
| Excel 2003 Error Cannot Locate the Internet Server or Proxy Server | Excel Discussion (Misc queries) | |||
| get SQL Server text data type into Excel pivot table | Excel Discussion (Misc queries) | |||
| problem updating link from Novell server to windows server #REF er | Excel Discussion (Misc queries) | |||
Threaded Mode
