view

M

Michael

I am creating a worksheet that uses references from other
worksheets. Now that I am done I want to elliminate the
reference and still maintain the resulting number. Can
this be done with difficulty?
 
D

Dave Peterson

Does different worksheets mean different worksheets in different workbooks?

If yes, then in xl2002, you can Edit|links|Break links.

In all versions, you can just copy|paste special|values.

And to help find those pesky links:

Bill Manville's findlink.zip from:
http://www.BMSLtd.co.uk/MVP/Default.htm
 

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

Odd and even header and footers with section break 2
LISTNUM + Mail Merge + INCLUDETEXT : Referencing Paragraph # Can't get to work 0
Embed the same Excel multiple times 0
Problem with SET & REF function 0
Macro to select and delete levels of a document 2
Insufficient Memory or Disk Space. Close programs down? 0
Custom Number sequences 0
VBA Coding Help for Beginner 0

Top