Reference in the Application files

[Crystal]

Hi,

I recently did a complete data-copy from my Test to DEV server. After the data copy, all the Application files point to the Test server and so I am not able to see any data in my Excel files. Is there some way to change all the Application files to point to my DEV server?

I was told restoring the }Applications folder from the DEV backup would resolve this but the guide says the }Applications folder would have just the place-holder files for refrenced/uploaded files. I am not sure how to do this.
Very much appreciate your help.

Thanks,
Crystal

[David Usherwood]

The simplest way is to open the workbooks and to a global search and replace for xxx_test: to xxx_dev:
On the face of it that would involve republishing them to the server. Since the workbooks are stored in the }Externals folder I think it could work to open them directly there. You could even write a VBA macro to process all of them in one pass.

[Crystal]

Thanks Dave
We finally resorted to global search and replace!