Moving machines - Dynamic range - #REF!

[johnlewisdesign]

Hi I have a workbook which contains many worksheets, all referenced via a dynamic named range, collating data as they are added. I learned everything here, so thank you!

For example I have
datacollection1 through datacollection81 in a column, as per the sheet names.

These sheet names are stored in a dynamic named range in another sheet. These are then calculated using COUNTIF and INDIRECT to summarise survey data. On my machine in Excel 2007 PC things calculate perfectly.

When my client opens the file on a different machine via Excel 2010 PC, all the calculations are gone and replaced with #REF! - the same happens on a Mac using Excel 2004. Its like the dynamic named ranges don't exist.

I have no external links, no outside references, just internal calculations.

What occurs yonder? Its driving me mad. My client is screaming at me

Thanks!

 

[johnlewisdesign]

OK upon further inspection it appears to be referencing the sheets I took the data from, even though I did a copy, and severed all links to external sheets! I'll start a more relevant thread.