One More Try: Names/Apply on other worksheet



Giving this one more shot before i start to spend the next manually replacing
cell locations in formulas with names. Here's the situation:

I have 17 workbooks with 8 worksheets each that were given to me. I went
through all the entire workbooks and named all the important cells and cell
ranges with global names. Then I went to "apply" the names to cells with
calculations where by the cell location would be replaced with the names.

The APPLY function works just fine in replaceing cell locations with NAMES
that were created on the same page. But it does not work when trying
to apply names to calculations that reference cell ranged named on different

For example: on worksheet1 cell D7 contains =SUM(A7:C7) and is globally
name MyTotal. On worksheet2, cell C4 contains =Sheet1!D7

If I do Insert/Names/Apply/MyTotal on worksheet2, cell C4 I get the response:
"Microsoft Excel cannot find any references to replace". And if I simply
type =MyTotal in any cell on worksheet2, the proper value from worksheet1

Is there any way to replace these names other than manually?

Thanks. Mike




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