How do I link two excel workbooks?



How do I link two excel workbooks?..

Answer / Anoop Agarwal

"To link two Excel workbooks, you can use the "External References" feature. Click on "Formulas" tab in the ribbon and then select "Define Name". In the dialog box, enter a name for the reference, choose the type as "Range", specify the location of the range in the second workbook, and click "OK."

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More MS Excel Microsoft Interview Questions

What is the shortcut for bold in excel?

1 Answers  


How many rows and columns 2019 excel?

1 Answers  


What does '!' Mean in excel?

1 Answers  


What is a combination chart?

1 Answers  


How do I find duplicates in multiple columns in excel?

1 Answers  


Using excel is there a way to close all open excel files at once instead of closing them one at a time?

1 Answers  


How do I change the value of a cell in excel?

1 Answers  


How do I add a trendline in excel?

1 Answers  


What is the syntax of vlookup?

1 Answers  


How do you group worksheets together?

1 Answers  


What are constants used for?

1 Answers  


What is the use of concatenate formula in excel?

1 Answers  


Categories