Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data extraction... (Pls Help)
Hi, I have a Pivot table in a worksheet. The data source is from another workbook (worksheet) that is password protected. Is it possible to get the data for the pivot table from the password protected worksheet without opening the actual workbook itself...?? Can anyone help out..??? -- Ahmed Sidat ------------------------------------------------------------------------ Ahmed Sidat's Profile: http://www.excelforum.com/member.php...o&userid=20621 View this thread: http://www.excelforum.com/showthread...hreadid=380547 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data extraction... (Pls Help)
yep.
start the pivot wizard. select EXTERNAL DATA source....(not Excel list or database) click getdata... you'll get the data source selection that you should be familiar with from data/import external et voila! -- keepITcool | www.XLsupport.com | keepITcool chello nl | amsterdam Ahmed Sidat wrote : Hi, I have a Pivot table in a worksheet. The data source is from another workbook (worksheet) that is password protected. Is it possible to get the data for the pivot table from the password protected worksheet without opening the actual workbook itself...?? Can anyone help out..??? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data extraction... (Pls Help)
keepITcool, Hey thanks alot. I have used 'external source' before but it just didnt occur to me that I could use that to do what I want. Got it working. Once again, thanks alot.. :) :) :) -- Ahmed Sidat ------------------------------------------------------------------------ Ahmed Sidat's Profile: http://www.excelforum.com/member.php...o&userid=20621 View this thread: http://www.excelforum.com/showthread...hreadid=380547 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I set up my data extraction | Excel Worksheet Functions | |||
Data Extraction | Excel Discussion (Misc queries) | |||
data extraction | Excel Discussion (Misc queries) | |||
data extraction | New Users to Excel | |||
Data Extraction | Setting up and Configuration of Excel |