I have an error (or dont understand the workings of the new version of
excel). I have a workbook G:\2009\Monthly Reporting Working Files\P05\Trial
Balance\YTD Financials.xlsx. This workbook is linked to the period 04 version
workbook (G:\2009\Monthly Reporting Working Files\P04\Trial Balance\YTD
Financials.xlsx). Note it is has the same file name but is held in a
different location.

It links to cell D47 of period 4 and then adds current month. The formula
works ok but when I save the document the links get broken and the cells
become a circular reference. I cant understand why.

I have the drive set up in my trusted locations, I am using the correct file
extension in my formula and my security settings are set on prompt for
workbook links.

Does anyone know how to find out how to ensure the formla is not changed?

Try changing the name of the workbooks, to something like Financials04, and
financials05.

hth
Vaya con Dios,
Chuck CABgx3



"Mike" wrote:

I have an error (or dont understand the workings of the new version of
excel). I have a workbook G:\2009\Monthly Reporting Working Files\P05\Trial
Balance\YTD Financials.xlsx. This workbook is linked to the period 04 version
workbook (G:\2009\Monthly Reporting Working Files\P04\Trial Balance\YTD
Financials.xlsx). Note it is has the same file name but is held in a
different location.

It links to cell D47 of period 4 and then adds current month. The formula
works ok but when I save the document the links get broken and the cells
become a circular reference. I cant understand why.

I have the drive set up in my trusted locations, I am using the correct file
extension in my formula and my security settings are set on prompt for
workbook links.

Does anyone know how to find out how to ensure the formla is not changed?

Hi,

Changing the names is the obvious answer but I was trying to understand the
true workings of the new version. We seem to think it has something to do
with connections but just can't figure it out.

Best Regards
Mike

"CLR" wrote:

Try changing the name of the workbooks, to something like Financials04, and
financials05.

hth
Vaya con Dios,
Chuck CABgx3



"Mike" wrote:

I have an error (or dont understand the workings of the new version of
excel). I have a workbook G:\2009\Monthly Reporting Working Files\P05\Trial
Balance\YTD Financials.xlsx. This workbook is linked to the period 04 version
workbook (G:\2009\Monthly Reporting Working Files\P04\Trial Balance\YTD
Financials.xlsx). Note it is has the same file name but is held in a
different location.

It links to cell D47 of period 4 and then adds current month. The formula
works ok but when I save the document the links get broken and the cells
become a circular reference. I cant understand why.

I have the drive set up in my trusted locations, I am using the correct file
extension in my formula and my security settings are set on prompt for
workbook links.

Does anyone know how to find out how to ensure the formla is not changed?

Probably because, with this procedure Excel is being asked to open two
instances of the same filename and it's don't like to do that.

Vaya con Dios,
Chuck, CABGx3



"Mike" wrote:

Hi,

Changing the names is the obvious answer but I was trying to understand the
true workings of the new version. We seem to think it has something to do
with connections but just can't figure it out.

Best Regards
Mike

"CLR" wrote:

Try changing the name of the workbooks, to something like Financials04, and
financials05.

hth
Vaya con Dios,
Chuck CABgx3



"Mike" wrote:

I have an error (or dont understand the workings of the new version of
excel). I have a workbook G:\2009\Monthly Reporting Working Files\P05\Trial
Balance\YTD Financials.xlsx. This workbook is linked to the period 04 version
workbook (G:\2009\Monthly Reporting Working Files\P04\Trial Balance\YTD
Financials.xlsx). Note it is has the same file name but is held in a
different location.

It links to cell D47 of period 4 and then adds current month. The formula
works ok but when I save the document the links get broken and the cells
become a circular reference. I cant understand why.

I have the drive set up in my trusted locations, I am using the correct file
extension in my formula and my security settings are set on prompt for
workbook links.

Does anyone know how to find out how to ensure the formla is not changed?