Associate
- Joined
- 4 Apr 2006
- Posts
- 171
- Location
- Hertfordshire
Hi All,
Im in the process of moving a lot of data to a new server, and have hit a rather big wall!
I have a number of Excel spreadsheets which have links to other Excel documents.
In the original location they are ok they open and save/close fine. but when they are copied to the new location, they open ok, but saving them takes over an hour!
Obviously this will just cause too many headaches, but I cannot leave them on the old server as I would like to throw it out soon due to its ageing hardware...
I have tried looking at the links. remaking them. doing a save as to copy them to the new location. have even tried copying them to a total different location altogether but they only appear to work from the original location correctly.
Is there anything I could try. I have search the net for an answer but can only come up with ways to speed up excel which doesnt help.
Im in the process of moving a lot of data to a new server, and have hit a rather big wall!
I have a number of Excel spreadsheets which have links to other Excel documents.
In the original location they are ok they open and save/close fine. but when they are copied to the new location, they open ok, but saving them takes over an hour!
Obviously this will just cause too many headaches, but I cannot leave them on the old server as I would like to throw it out soon due to its ageing hardware...
I have tried looking at the links. remaking them. doing a save as to copy them to the new location. have even tried copying them to a total different location altogether but they only appear to work from the original location correctly.
Is there anything I could try. I have search the net for an answer but can only come up with ways to speed up excel which doesnt help.