Problem with Linked Cells

[Charliemike83]

Can someone please help. I have two workbooks, the first one (Dat
Capture) has all my raw data and is linked to the second (Summary
which summarises it all. The problem I'm having is that cell C2 i
workbook one (Data Capture) contains a large amount of open text (9
words) and is linked to cell H17 in workbook two (Summary).

When I open workbook two (Summary) on its own and update the link onl
50 words of the text appears in cell H 17, but if I open workbook on
(Data Capture) then workbook two (Summary) and update the link all th
text appears in cell H17.

Is there a way of updating workbook two (Summary) with all the text i
cell H17 without opening workbook one (Data Capture)

Thanks - Charliemik

 

[Jan Karel Pieterse]

Hi Charliemike83,

Is there a way of updating workbook two (Summary) with all the text in
cell H17 without opening workbook one (Data Capture)

Not as far as I know. Maybe using a macro or Data, Get external data.

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com

 

[Charliemike83]

Thanks Jan,

Anyone else any ideas if this is possibl

 

[Dave Peterson]

Use a few helper cells in the original workbook and split the text up there.

Then retrieve the values from those helper cells and concatenate them in the
other workbook.

 

[Charliemike83]

Thanks Dave

Will try it out