bigfishyuk
New Member
- Joined
- Feb 13, 2013
- Messages
- 4
Im not sure whether this is an Excel or Word issue as we currently have data in Excel which is then loaded into a user form in Word.
This has worked fine for a long time but recently we have developed an issue where the user form takes a few minutes to open if the spreadsheet containing the data is open. If is isnt open it takes seconds to open. It is the same on other userform we have in other documents so im sure its not the code that has been changed.
We can get round the issue by continually opening and closing Excel but it isnt the most convenient process.
Any thoughts would be appreciated.
Thanks
Nigel
This has worked fine for a long time but recently we have developed an issue where the user form takes a few minutes to open if the spreadsheet containing the data is open. If is isnt open it takes seconds to open. It is the same on other userform we have in other documents so im sure its not the code that has been changed.
We can get round the issue by continually opening and closing Excel but it isnt the most convenient process.
Any thoughts would be appreciated.
Thanks
Nigel