LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
zimon72
 
Posts: n/a
Default Linking cells: open source to update values


Hi there,

I created a source file (.csv) that contains two columns and several
rows. This source file is filled (updated) by a SQL process that runs
everyday.

The source file is input for a report in Excel. I would like to
automatically update the Excel report when it is opened. However,
although it looks like I linked the correct file, worksheet and range,
I can only update the Excel report after I manually open the source
file. But that's not what I want, I don't want to see the source file.

Anyone?


--
zimon72
------------------------------------------------------------------------
zimon72's Profile: http://www.excelforum.com/member.php...o&userid=30592
View this thread: http://www.excelforum.com/showthread...hreadid=502398

 
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
linked values not displayed unless source file open Sandyc Excel Discussion (Misc queries) 1 October 7th 05 02:18 PM
Reference multiple cells in if statement PAR Excel Worksheet Functions 1 June 10th 05 06:28 AM
Pivot Table Auto Update Data Source? Ket Excel Worksheet Functions 1 February 18th 05 11:14 PM
How does one update and transfer values between cells and not the. JC Excel Discussion (Misc queries) 0 January 12th 05 08:29 PM
XL2003 Destination and Source Open but not updating tim Excel Discussion (Misc queries) 2 December 14th 04 01:29 AM


All times are GMT +1. The time now is 01:14 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"