Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Pivot table - refresh with close Wkb range dynamic

Status
Not open for further replies.
bojzon

bojzon

IS-IT--Management
Sep 18, 2003
25
SI
Need help with correct reference with two workbooks with more then 1 sheets.
First one Wkb is opened and other Wkb is closed (could not open both , because of RAM resources). PT from opened is referenced to closed Wkb range (ex.: \Plan\Plan2006\ Model.xls!RangeDynamic).
How input correct reference with input box (not accept C:\...) ?
VBA syntax?

Thanks
Bojzon
 
Status
Not open for further replies.

Similar threads

M
  • Locked
  • Question
Reference Pivot Tables by name 1
Replies
2
Views
834
mintjulep
M
remeng
  • Locked
  • Question
Delete dynamic table rows without removing password protection
Replies
7
Views
635
remeng
remeng
remeng
  • Locked
  • Question
Getting results from a dynamic dimension array
Replies
2
Views
707
Andrzejek
Andrzejek
dgillz
  • Locked
  • Question
Back coloring an entire row if a duplicate is found in a dynamic range 1
Replies
18
Views
907
SkipVought
S
arvarr
  • Locked
  • Question
Variable in Pivot Table 1
Replies
4
Views
387
arvarr
arvarr

Part and Inventory Search

Sponsor

Back
Top