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

0 votes
asked by
edited by

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?

1 Answer

0 votes
answered by (264k points)

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.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
Anti-spam verification:
To avoid this verification in future, please log in or register
...