Hi,
we've got a large .xl spreadsheet with alot of VBA behind it that is delivered to clients in a variety of locations running various concoctions of XP/2000/NT and office 2000,2002/2003, and to date it has been robust with clients sending copies of the .xl file to each other etc.
One of our clients reported an issue when he generated a copy of the .xl file on a Citrix network and then tried to send it to another client running a desktop office install. The 'missing reference' problem reared up and crashed the .xl sheet load. (I located it to RefEdit.dll). I think this is a latent problem that has gone unnoticed till now.
It seems as though the client cannot create copies of our .xl file on Citrix and then use them on a desktop install, and vice versa.
Has anyone come across similar problems when moving files from Citrix to desktop and vice-versa? I have no experience of Citrix. I think we could probably fix this at our end using late binding(?), but clients will not recieve this until the next annual rollout, and those running Citrix are in a very small minority.
Any help or ideas much appreciated!
Adam
Start Free Trial