Problem with Linked Cells

  • Thread starter Thread starter Charliemike83
  • Start date Start date
C

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
 
Hi Charliemike83,
Is there a way of updating workbook two (Summary) with all the text in
cell H17 without opening workbook one (Data Capture)
Click to expand...

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
 
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.
 
Back
Top