ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Linking Spreadsheets (https://www.excelbanter.com/new-users-excel/265535-linking-spreadsheets.html)

Fritolady

Linking Spreadsheets
 
I'm trying to link one worksheet to a master sheet and have the one I'm linking automatically populate what I type into the master spreadsheet. However, when I tell it = and then click the cell, the FORMULA for that cell shows up, and not the data itself??

Any ideas of what I'm doing wrong or what I need to change??

**As a matter of fact, I'm doing this for a coworker - it doesn't work on his computer, but it works on mine???

wickedchew

Quote:

Originally Posted by Fritolady (Post 958984)
I'm trying to link one worksheet to a master sheet and have the one I'm linking automatically populate what I type into the master spreadsheet. However, when I tell it = and then click the cell, the FORMULA for that cell shows up, and not the data itself??

Any ideas of what I'm doing wrong or what I need to change??

**As a matter of fact, I'm doing this for a coworker - it doesn't work on his computer, but it works on mine???

Check the cell formatting, it should be set to GENERAL and not as TEXT.


All times are GMT +1. The time now is 12:42 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com