ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Updating a .XLA sheet referenced by a Client Sheet (https://www.excelbanter.com/excel-programming/388685-updating-xla-sheet-referenced-client-sheet.html)

J Streger

Updating a .XLA sheet referenced by a Client Sheet
 
I have a Client and A server Excel Sheet. The client sheet references the
server sheet to get access to the variables and forms, etc.

The only issue is that all users need to have the sheet closed down in order
to update the referenced client .xla. Is there any way be able to update and
replace the .xla reference without asking the users to shut down their
clients?

Using Excel 2003

--
*********************
J Streger
MS Office Master 2000 ed.
MS Project White Belt 2003



All times are GMT +1. The time now is 03:54 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com