Changing cell reference

[chabuk1]

Hi,
I am kind of stuck with one problem. I am referencing some cells from a different sheet in my main sheet. Now I have to change the location of these sheets. But the problem is that the path will not be the same and I will run into issues.
Is there a way to resolve this?

Regards,

Chabuk

 

[perco754]

What do you mean by changing location? Are the sheets remaining in the origin workbook?

 

[chabuk1]

No I mean - The cells are in a different file and the main sheet is a different file. So if I move both these files to a different folder it will not update the path right?

Regards,

Chabuk

 

[chabuk1]

I mean there are 2 separate files - The main sheet and the one from which it is getting the input. So if I change the location of these files to a different folder, there will be errors?

Regards,

Chabuk

 

[perco754]

Ok, if you change the location of the workbook the reference path needs to be updated. You will get a question from Excel each time you're opening the workbook with the reference, so that you can update to the new path.

 

[chabuk1]

Thanks for your response.
Isnt there a way to automate this?

Regards,

Chabuk

 

[RichardMGreen]

If you open both files in the same instance of Excel and save them using F12 (SaveAs), the relative paths will be updated automatically.