PDA

View Full Version : Update Question



anthony20069
01-07-2009, 04:15 AM
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
01-07-2009, 04:33 AM
This isn't helpful, but maybe you could try using commas in your sentences :P

Have you tried cellotape?:banghead::banghead:

anthony20069
01-07-2009, 04:35 AM
If you have nothing usfull to say, please be quite.......RICHARD!!!

bdayboy
01-07-2009, 04:40 AM
If you have nothing usfull to say, please be quite.......RICHARD!!!

:devil2: SORRY!

georgiboy
01-07-2009, 04:44 AM
I run Excel 2007 so it is slightly different, maybe you could use something like this.

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

Hope this helps

xld
01-07-2009, 05:10 AM
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.