ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Auto Update Linked data (https://www.excelbanter.com/excel-worksheet-functions/209025-auto-update-linked-data.html)

Ingebelle''s

Auto Update Linked data
 
spreadsheet (a) that was open before new data saved as another spreadsheet
(b) no longer updates automatically without opening & closing (a) or using
the EditLinks feature. I believe the auto refresh disappeared when my
company upgraded MS Office from Proffesional to XP. Using Excel 2003.

ShaneDevenshire

Auto Update Linked data
 
Hi,

Try - In the workbook with links, choose Edit, Links, Startup Prompt and
choose the first option.

--
Thanks,
Shane Devenshire


"Ingebelle''s" wrote:

spreadsheet (a) that was open before new data saved as another spreadsheet
(b) no longer updates automatically without opening & closing (a) or using
the EditLinks feature. I believe the auto refresh disappeared when my
company upgraded MS Office from Proffesional to XP. Using Excel 2003.


Ingebelle''s

Auto Update Linked data
 
The 1st option in EditLinksStartup Prompt was already selected.

"ShaneDevenshire" wrote:

Hi,

Try - In the workbook with links, choose Edit, Links, Startup Prompt and
choose the first option.

--
Thanks,
Shane Devenshire


"Ingebelle''s" wrote:

spreadsheet (a) that was open before new data saved as another spreadsheet
(b) no longer updates automatically without opening & closing (a) or using
the EditLinks feature. I believe the auto refresh disappeared when my
company upgraded MS Office from Proffesional to XP. Using Excel 2003.


Ingebelle''s

Auto Update Linked data
 
This did not help. Anything else to try?

"Ingebelle''s" wrote:

The 1st option in EditLinksStartup Prompt was already selected.

"ShaneDevenshire" wrote:

Hi,

Try - In the workbook with links, choose Edit, Links, Startup Prompt and
choose the first option.

--
Thanks,
Shane Devenshire


"Ingebelle''s" wrote:

spreadsheet (a) that was open before new data saved as another spreadsheet
(b) no longer updates automatically without opening & closing (a) or using
the EditLinks feature. I believe the auto refresh disappeared when my
company upgraded MS Office from Proffesional to XP. Using Excel 2003.



All times are GMT +1. The time now is 07:57 PM.

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