ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Linked Formulas have stopped working! (https://www.excelbanter.com/excel-worksheet-functions/120953-linked-formulas-have-stopped-working.html)

Jules

Linked Formulas have stopped working!
 
I have a workbook with many spread sheets. The spreadsheets are linked to
one sheet that totals all the volume.

=SUM(Kent:Theyagaraj!F6)

Kent:Theyagaraj is the range of tabs I need to calculate, this is on the
total volume spread sheet.

=Abramowitz!F6

Is the name of an individual spreadsheet and the range/cell I need to have
the info transfer to the bigger spread sheet. (Abramowitz is in the range
(kent:Theyagaraj)

These links have been in place for years...each FY we copy the worksheets
over...just suddenly started having a problem.

Any help would be great.

Thanks so much and have a great day.
--
Jules


All times are GMT +1. The time now is 02:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com