View Full Version : [SOLVED:] Prevent automatic updating
I have a spreadsheet that is linked to a data filed from Bloomberg. How do i prevent the spreadsheet form automatically updating itself upon opening.
Unfortunately I cannot attach the example as the data is a Bloomberg source.
thanx
Jacob Hilderbrand
03-27-2005, 08:21 PM
Edit
Links...
Startup Prompt...
Don't display the alert and don't update automatic links
OK
Cyberdude
03-28-2005, 09:47 PM
Could you possibly make use of
Application.Calculation = xlManual
to prevent updates?? It would have to be set before closing the workbook.
brettvba
03-29-2005, 12:50 AM
That will stop the calculations, the updates I assume Jake has assumed is the links of data in another workbook not the calculations.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.