0

Everytime I click Update when I open the Excel document the data is lost. I link to some external documents. If I open those documents the data reappears. The formula with the link looks something like this:

=SUMIF('\\adress\folder\folder\folder\folder\folder\folder\folder\folder\[Linia1.xls]BD'!$A$2:$A$65536,A19,'\\address\folder\folder\folder\folder\folder\folder\folder\folder\[Linia1.xls]BD'!$AR$2:$AR$65536)
Andrei Ion
  • 1,777
  • 15
  • 34
  • 54
  • I think this is the standard behavior of Excel formula with external data. Maybe you should try `GetInfoFromClosedFile()` as suggested in one of your previous question: http://stackoverflow.com/questions/7401967/copy-data-from-another-workbook-through-vba/ – JMax Nov 01 '11 at 19:41
  • GetInfoFromClosedFile() might work but I'm not using VBA in this one. – Andrei Ion Nov 02 '11 at 06:52
  • Maybe you could try a UDF? But I'm not sure that would be enough... – JMax Nov 02 '11 at 09:07

1 Answers1

0

Though it is annoying, it is not a bug but a feature as JMax suggested. To make your life more convenient you could consider adding a few hyperlinks to the workbooks that need to be open.

Dennis Jaheruddin
  • 21,208
  • 8
  • 66
  • 122