Problem with dynamic chart

[konradz]

I developed dynamic chart with use of the offset formula. The data range in a chart is expressed like that:

='time series profiler.xlsx'!income_y

After saving and closing file the formula alters itself and looks like that:

=[COLOR=#ff0000][B][0][/B][/COLOR]!income_y

Obviously, at this stage the chart loses the dynamic functionality and it is necessary to alter the data range manually. I'm utterly perplexed to why it happens.