ExcelBanter - activate mutiple links

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - activate mutiple links (https://www.excelbanter.com/excel-discussion-misc-queries/202640-activate-mutiple-links.html)

C Darling

activate mutiple links

I have some off the same problem as Iboti "How can I make multiple ..." (15-09)

I also have a large spreadsheet, with a lot of links to other spreadsheets.
But to activate them I have to press F2 and enter at each cell. Is there an
easier way?

Gary''s Student

activate mutiple links

Is:

Edit Links Update values

working??
--
Gary''s Student - gsnu200805

C Darling

activate mutiple links

No, it did't

"Gary''s Student" skrev:

Is:

Edit Links Update values

working??
--
Gary''s Student - gsnu200805

Gary''s Student

activate mutiple links

Perhaps the expressiosn are just not re-calculating. Try:

Tools Options... . Calculation Automatic
--
Gary''s Student - gsnu200805

"C Darling" wrote:

No, it did't

"Gary''s Student" skrev:

Is:

Edit Links Update values

working??
--
Gary''s Student - gsnu200805

C Darling

activate mutiple links

I have also tried that with no results

"Gary''s Student" skrev:

Perhaps the expressiosn are just not re-calculating. Try:

Tools Options... . Calculation Automatic
--
Gary''s Student - gsnu200805

"C Darling" wrote:

No, it did't

"Gary''s Student" skrev:

Is:

Edit Links Update values

working??
--
Gary''s Student - gsnu200805

All times are GMT +1. The time now is 10:43 PM.