PDA

View Full Version : [SOLVED] Prevent automatic updating



SUJU
03-27-2005, 08:04 PM
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.