Links

A

Anna

Hi,
I had a Excel file work at home, I copied some worksheets
from the file from home to the file at work; all the
formula show the link and formula instead of only show
formula. How do I change the link back to formular only?
Exp:=MED('G:\My''sDocument\Daily Folder\[Manufacturing
Ylds 04(w_charts).xls]ProductSummary'!L88:L300).
I just need =MED(ProductSummary'!L88:L300).

Thanks so much.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Show a cell's formula in text format in a linked cell 2
Linking data in MS Word into Excel 5
Links do not recognize .xlsm extension 1
Synchronization problems while moving folders to new email 1
change multiple links at once 1
Can't save my Office documents (after computer rebuild and reauthorization) 0
VBA - exporting serial letters to single documents 0
averaging from different sheets and folders 1

Top