I have a worksheet that has hyperlinked numbers from another workbook on our
server. I have tried to then SUM these numbers, but nothing happens. I am a
novice and actually just figured out how to hyperlink the info to get it to
my new workbook. Is there a way to add this column of numbers?
Jim Wash

JimWash wrote:
I have a worksheet that has hyperlinked numbers from another workbook on our
server. I have tried to then SUM these numbers, but nothing happens. I am a
novice and actually just figured out how to hyperlink the info to get it to
my new workbook. Is there a way to add this column of numbers?
Jim Wash

Copy them and paste them as values and then sum them.

Thanks for the advice. Is there a way for the program to do this on its own
or do I need to manually copy the columns each month?

"Stopher" wrote:


JimWash wrote:
I have a worksheet that has hyperlinked numbers from another workbook on our
server. I have tried to then SUM these numbers, but nothing happens. I am a
novice and actually just figured out how to hyperlink the info to get it to
my new workbook. Is there a way to add this column of numbers?
Jim Wash

Copy them and paste them as values and then sum them.

You could do an Workbook_open macro that on open, after the data is
updated, copies and pastes all the relevant columns/data so that they
are numbers.