linked cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

What command will find embedded linked cells and to change those cells to
hard values?
 
It's not easy to find.

May need to browse through the cells and detect the formula. An Excel tool
called auditing may help to relieve some pain. Go to Views, Toolbars and
check the Formula Auditing. There are two buttons, one called 'trace
precedents' and one 'trace descendants' that would show the link trail.

If you want to 'freeze' the value as populated in the cells with formulas,
simply select the whole sheet (by clicking the left top corner next to the
first column), copy, and go to edit, paste special and select value only

Hope this helps...
 
You must log in or register to reply here.

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

Excel Referencing one cell from a different worksheet and slide in powerpoint 0
Linking 4
Paste Values in linked Cells Only 4
How do I link to an embedded object 1
Numbers change in cell even when formatted as text 4
Can I remove formula but keep value with a simple command? 2
How to create absolue path link to another workbook (Excel 2003) 1
TextBox linked to cell????? 4

Back
Top