Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 27th 09, 04:12 AM posted to microsoft.public.excel.links
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2009
Posts: 1
Default refreshing data from a linked *.dbf database file without opening it.

I have a excel pivot table with an external database (a *.dbf file).
Is there anyway to refresh the pivot table without actually opening the
*.dbf file?

When I tried to refresh the pivot table without opening the *.dbf file
first, it complain that the link contains one or more database that can not
be updated... (or something like that).

If I open the *.dbf file first the the refresh works and update the data
correctly.

Thanks in advance for any helps or hints.

Ahrder.


Reply
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
Displaying linked data in excel 2007 when linked file is not avail Eng_19 Excel Discussion (Misc queries) 0 December 7th 07 07:27 PM
saving and refreshing workbook linked to a SQL database Texas Tonie[_2_] Excel Discussion (Misc queries) 0 November 9th 07 11:03 PM
Refreshing a linked Access Database Rob Excel Discussion (Misc queries) 0 October 17th 07 12:40 AM
Refreshing Excel worksheet with data linked from Access mcphc Excel Discussion (Misc queries) 1 March 23rd 07 05:16 PM
Refreshing when opening a file from the "File" Menu [email protected] Excel Worksheet Functions 0 May 16th 06 06:27 AM


All times are GMT +1. The time now is 11:04 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017