Excel 2007 changes graph source

[joeygbh]

Hi,

I've come against and error that is baffling me.

The graphs use a dynamic named range as the source data, for example:

='Report.xlsm'!DataRange

This works when originally setting up the graph but when it is saved and reopened the information changes to:

=[0]!DataRange

which causes the graph to fail. All the graphs in the workbook get changed in this manner.

Extra information:

Original file was created in Excel 2010 on a Windows 7 system stored in a folder on the desktop.

File was copied to a computer running Excel 2007 on Windows Server 2008 stored in a folder on the desktop.

The range comes from a OPC server connection that supplies the data depending on the range of time requested (1 hour, 1 day 1 week's worth of data etc.)

Any ideas why it is doing it?

 

[Jon Peltier]

This was a bug in the original version of Office 2007, and was corrected in one of the service packs, probably not SP1, but more likely SP2 or SP3. See if you can apply the service pack.

 

[joeygbh]

Thankyou I will try this first. I checked and it was an Excel no SP version.