WOrksheets

I have one file with two worksheets. They are both the same, but one
worksheet needs to be re arranged to be easier to read alter information
while the other has to remain in a certain format so it can be uploaded into
my accounting system.

They have been successfully linked, but when I g to re arrange the first
worksheet, it automatically re arranges the second worksheet when I dont want
it to.

The current formula I have is =Worksheet!$D$2

Thanks

Hi Smirlface,

Re-arrange the second worksheet instead.

--
Cheers
macropod
[Microsoft MVP - Word]


"Smirlface" wrote in message ...
I have one file with two worksheets. They are both the same, but one
worksheet needs to be re arranged to be easier to read alter information
while the other has to remain in a certain format so it can be uploaded into
my accounting system.

They have been successfully linked, but when I g to re arrange the first
worksheet, it automatically re arranges the second worksheet when I dont want
it to.

The current formula I have is =Worksheet!$D$2

Thanks

unfortunately the second worksheet with the formula in it has to remain in
that format as it needs to be uploaded into an accounting system

"macropod" wrote:

Hi Smirlface,

Re-arrange the second worksheet instead.

--
Cheers
macropod
[Microsoft MVP - Word]


"Smirlface" wrote in message ...
I have one file with two worksheets. They are both the same, but one
worksheet needs to be re arranged to be easier to read alter information
while the other has to remain in a certain format so it can be uploaded into
my accounting system.

They have been successfully linked, but when I g to re arrange the first
worksheet, it automatically re arranges the second worksheet when I dont want
it to.

The current formula I have is =Worksheet!$D$2

Thanks
.