Linking worksheets in Excel 2000

[msmigraine]

I have a workbook which contains 2 sheets. Sheet 2 is a copy of Sheet 1 only difference being that I have opted to display sheet 2 as formulas vs. data. My quandry is that I want to "link" sheet 2 to sheet 1 so that any updates I make to sheet 1 automatically update on sheet 2 without interfering with the formula I have presently displayed on sheet 2?

 

[flaniganmj]

migraine,

I don't really understand your problem, the last part at least. If you want to simply see the formulas, use (Ctrl + `), which is above the tab key. With this, you can flip back and forth between formulas and data. If you want another sheet with the formulas, write a macro/procedure to delete the old copy and insert a new copy while setting .DisplayFormulas = True. Let me know if I am completely misunderstanding the problem.

flan

 

[msmigraine]

Thank you for the reply flan - sorry for the confusion. I have no issue with displaying the formulas on Sheet 2 (Sheet 2 is simply a copy of Sheet 1 created for the sole purpose of displaying the formulas). My question is how can I then link Sheet 2 to Sheet 1 so that any updates I make to sheet 1 (formulas and/or data) would also appear on Sheet 2 - I am a fairly new user to Excel and I am familiar with the formula (='Sheet1'!C60) which would work if I were not displaying formulas on Sheet 2 - as soon as I attempt to add the above to my existing formula I get a circular ref. error. Is it possible to have both - formula displayed + link to original Sheet/Cell for update purposes? I hope that makes sense - I'm rambling.

 

[flaniganmj]

I still don't think I understand completely.

-Sheet2 is a pasted copy of Sheet1.
-When Sheet1 is updated, Sheet2 is not
-All updating is done on Sheet1
-So you want Sheet2 to be an exact replica of Sheet1, only showing formulas.

If I am stating this correctly, I still think you should just go to Sheet1 and hit (Ctrl + `). You can continue to toggle back and forth this way.

If you must have it on another sheet, I would recommend writing a macro/procedure to simply remove the old Sheet2 and replace it with a new one in which view formulas are visible.

However, it is very likely I still don't understand.

flan

 

[msmigraine]

I believe that you have hit the nail right on the head flan - unfortunatly I must keep the present layout, although I do agree that the shortcut (Ctrl + ') would be much more functional. My skill level with this application is fairly low and I have no clue how to create the macro you are referencing.