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

Linking cells: open source to update values
 

I believe that if the file is a text file it has to be opened in Excel for
the update to occur, as the text file does not have and cell address
references.

Outputting the linked file as an Excel file would correct this problem.
--
Kevin Backmann


"zimon72" wrote:


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

Linking cells: open source to update values
 

How do I do that? Just giving an .xls entension to my output doesn't
split my data into columns!


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