ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Updating Automatic links doesn't work with arrays (https://www.excelbanter.com/excel-discussion-misc-queries/2164-updating-automatic-links-doesnt-work-arrays.html)

Mats Samson

Updating Automatic links doesn't work with arrays
 
I've created a business calculation program in Excel and have used it for
years. Now using Excel 2003 SP1. My program uses a currency rate table from
another Excel file. The table is linked to the currency file within an array.
Suddenly, when I open the file/starting Excel it protests that the workbook
contains links that cannot be automatically updated. After checking every
link I have, I finally found that removing the array stops the message from
appearing.
I've tried to unset and reset the updating (in Tools/Options/Edit and even
in Edit/Links) but it won't work again.
What have happened?


All times are GMT +1. The time now is 04:32 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com