When I link a cell in one worksheet with another it only shows the formula for the link and not the data. What am I doing wrong?

First time here? Check out the FAQ!

x

0 votes

In most of the cases, you need to append the equal **=** inside the cell before you can type the formula, something like this: **=SUM(A1:A10)**. If the equal sign is missing, Excel, or any other spreadsheet editor won't know what you're typing in that cell. By appending the equal sign, you tell the application, that you have a formula with elements that needs to be solved.

...