I have a spreadsheet that I created in Excel 2011 for the Mac. In it, I am able to create a dynamic print range and it works well.

However when I open the spreadsheet in Excel 2010 for Windows, I look at the named ranges and my dynamic print range has becomes static.

The worksheets that I am printing contain formulae in cells down to row 101. I calculate the last row that has printable data and place that in a named range called Last_Row. I then refer to Last_Row when I calculate the print area in the named range "Print_Area".

As I said, on my Mac when the number of rows with printable data changes, so does the number of pages printed. In Excel 2010, however, the range "Print_Area" becomes static and doesn't update as the number of printable rows changes.

Has anyone had this issue before, or know the solution?

## Update

I also have the same behaviour in Excel 2013.

The formula that I am using is:

```
=OFFSET('Run1'!$A$1,0,0,'Run1'!Last_Row,9)
```

The value "Last_Row" is also a named range and it works without any problems on any version of excel.