Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
linked values not displayed unless source file open | Excel Discussion (Misc queries) | |||
Reference multiple cells in if statement | Excel Worksheet Functions | |||
Pivot Table Auto Update Data Source? | Excel Worksheet Functions | |||
How does one update and transfer values between cells and not the. | Excel Discussion (Misc queries) | |||
XL2003 Destination and Source Open but not updating | Excel Discussion (Misc queries) |