LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Todd1
 
Posts: n/a
Default Pivottable - Accessing file from network

I have successfully created Dynamic Ranges to access excel data that is
constantly changing in the number of rows.

It only seems to work if the data spreadsheet is open. I've used the Browse
button to specify the exact location of the spreadsheet, but it won't hunt
for it correctly on the network.

Any suggestions?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Weird File Open/Save As Behavior [email protected] Excel Discussion (Misc queries) 0 December 9th 05 02:26 AM
Excel file automatically opens Lost4Now Excel Discussion (Misc queries) 6 December 4th 05 09:35 PM
Pivottable across network mmwheeler Excel Worksheet Functions 0 July 26th 05 01:36 PM
Unable to save file to Windows 98 network folder jj Excel Discussion (Misc queries) 4 March 5th 05 07:59 PM
Network access to file - read only property AL Excel Discussion (Misc queries) 1 December 2nd 04 01:22 AM


All times are GMT +1. The time now is 11:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"