Linking Data in Workbooks

[VMathews]

I'm having a problem with linking data in a workbook. I've created a input sheet. When I link then data to pull Year I get the following reference:


Periodic
ACTUAL
=Input!$g$27


I've checked the formatting etc but it is set up the same as the cell that is working. Working in Excel 2010. Any assistance will be appreciated.

Thanks

[vnzerem]

You need to upload a sample spreadsheet to clarify your problems

[VMathews]

See attached excel file for display of error.


Thanks

[vnzerem]

I looked at your spreadsheet and I really don't see any problems with it. I guess you were linking it wrong. I have attached your spreadsheet here and all the links are working. Don't forget to mark the thread as solved if I solved your problem and don't forget to click the star (add reputation)

[VMathews]

Thanks you! Got what I needed!

[vnzerem]

There is nothing special, I just linked it and it worked....Don't forget to mark the thread as solved if I solved your problem and don't forget to click the star (add reputation

[vnzerem]

The only thing I noticed was that your format on the "Extended Warranty Summary" sheet was in text instead of General...Don't forget to mark the thread as solved if I solved your problem and don't forget to click the star (add reputation

[VMathews]

Thank you.... Problem Solved

[vnzerem]

To mark your thread as solved, go to Thread Tools > Click on "Mark This Thread as Solved"