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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel / Sql Server / Pivot Tables
The answer is yes. The files name can be a pathname, a networkname or a web
name All these are exquivalent FName = "c:\temp\MyDir" FName = "\\InternalAddress\MyDir" FName = "Http:\\URLName\MyDir" "WCM" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel / Sql Server / Pivot Tables
Thank you, Joel - am working to set up some tests. We have found no better
way to present most financial/operations data than Excel pivot tables - fast, inexpensive, user-friendly, and information-rich. If we can implement refreshable pivots over the web, we have the only solution we need (and would be hard pressed to think of a better one, regardless of cost). "joel" wrote: The answer is yes. The files name can be a pathname, a networkname or a web name All these are exquivalent FName = "c:\temp\MyDir" FName = "\\InternalAddress\MyDir" FName = "Http:\\URLName\MyDir" "WCM" wrote: 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 |
Reply |
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) |