Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook open event
Hi, I have a price master sheet (2MB) in the server and a lookup sheet in
every workstation. When the lookup sheet loading up, it takes two minutes to link to the master sheet. I am thinking of copying this master file from the server to the workstation every time when users load up the lookup sheet. How can I do this? Thank you. GL |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook open event
GL
Put this in every workbook at the workstation. (Change the name and location of the Price master of course) Private Sub Workbook_Open() Workbooks.Open Filename:="F:\Shared\Price Master.xls", UpdateLinks:=True End Sub -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "G Lam" wrote in message ... Hi, I have a price master sheet (2MB) in the server and a lookup sheet in every workstation. When the lookup sheet loading up, it takes two minutes to link to the master sheet. I am thinking of copying this master file from the server to the workstation every time when users load up the lookup sheet. How can I do this? Thank you. GL |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook open event
Nick,
Thank you. That helps. After the files opened, the active sheet is the Price Master.xls. How can I switch it to the lookup sheet instead? Thank you. GL "Nick Hodge" wrote in message ... GL Put this in every workbook at the workstation. (Change the name and location of the Price master of course) Private Sub Workbook_Open() Workbooks.Open Filename:="F:\Shared\Price Master.xls", UpdateLinks:=True End Sub -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "G Lam" wrote in message ... Hi, I have a price master sheet (2MB) in the server and a lookup sheet in every workstation. When the lookup sheet loading up, it takes two minutes to link to the master sheet. I am thinking of copying this master file from the server to the workstation every time when users load up the lookup sheet. How can I do this? Thank you. GL |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook open event
Nick,
I solved that. Please ignore my previous email. GL "Nick Hodge" wrote in message ... GL Put this in every workbook at the workstation. (Change the name and location of the Price master of course) Private Sub Workbook_Open() Workbooks.Open Filename:="F:\Shared\Price Master.xls", UpdateLinks:=True End Sub -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "G Lam" wrote in message ... Hi, I have a price master sheet (2MB) in the server and a lookup sheet in every workstation. When the lookup sheet loading up, it takes two minutes to link to the master sheet. I am thinking of copying this master file from the server to the workstation every time when users load up the lookup sheet. How can I do this? Thank you. GL |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Workbook Open Event | Excel Programming | |||
Workbook Open Event | Excel Programming | |||
Workbook Open event | Excel Programming | |||
Workbook Open Event | Excel Programming | |||
Workbook Open Event | Excel Programming |