Excel spreadsheet operation.

Question

I have created an Excel spreadsheet and I want to link it to a field from my label, but when I change data on my spreadsheet values do not change on label. Is there a way to refresh data?

Answer 1

You have to do something like this:

Go into your spreadsheet and select the cell that you want to link to the cell from the work sheet. On this cell press '=' so that Excel will know that you want to enter a formula. Now go to the work sheet and click the cell that you want to link to. A doted line around this cell will automatically appear. Then hit Enter.