Update Question

[anthony20069]

Hi guys,

When you link a worksheet with another - is there a way to auto update it without having that popup window open everytime you open the workbook that is linked to another one?

Cheers

Anthony

[bdayboy]

This isn't helpful, but maybe you could try using commas in your sentences :P

Have you tried cellotape?

[anthony20069]

If you have nothing usfull to say, please be quite.......RICHARD!!!

[bdayboy]

If you have nothing usfull to say, please be quite.......RICHARD!!!

SORRY!

[georgiboy]

I run Excel 2007 so it is slightly different, maybe you could use something like this.

[VBA]Application.DisplayAlerts = False
'workbook to update from
ActiveWorkbook.UpdateLink Name:="C:\Example\Example.xls", Type:=xlExcelLinks
Application.DisplayAlerts = True[/VBA]

Hope this helps

[Bob Phillips]

If you have nothing usfull to say, please be quite.......RICHARD!!!

Whilst you may not have appreciated that point, it was a valid comment that your question was hard to read, and your response is not very good etiquette for someone seeking help.