external file references

Each month I create a report with over 100 summary tabs that are referencing 22 data tabs. All tabs are in the same file. The report works great! It is easily manipulated for all of the one-off requests I receive and the information is well presented and useful to my many customers. My...

Hi, I am trying to modify this VBA I found on the forum that is several years old. Sub Test() Const LinkName As String = "Book1.xlsx" Dim CalcMode Dim ws As Worksheet Dim WorkRange As Range Dim Cell As Range Dim FormulaParts As Variant Dim i As Integer Dim...

=IF([TimeSheets.xlsx]Tim!B12="_r2500",(SUM('[TimeSheets.xlsx]1st:Last'!$E$23)),"0.0") This works as expected; however, I need to expand the "Tim" worksheet to include 1st:Last. (When I attempt this, I receive a #REF error.) I don't understand why 1st:Last works in the SUM, but not in the IF...

I am working with a client who has a habit of copying formulas from a old version of a SS to a new one and in the process creating problems with external references. I have written a utility to step through the formulas and remove all the external references. However when I reassign the...