Linked Spreadsheets Grandfather Name Sticking

  • Thread starter Thread starter Dennis
  • Start date Start date
D

Dennis

Hello,

Here's an example of the problem.

Let's say I have a store that sells gasoline.

I want to record my store sales, and gasoline sales
in gallons.

So, I have a spreadsheet for store sales and a spreadsheet
for gas sales in gallons.

And these are setup per month. January sales sheets,
February sales sheets, etc.

I have the gas gallons spreadsheet linked to the stores
sales spreadsheet, so I can enter all the data while in
the sales spreadsheet.

Let's say I have entered all of January's sales and gas
data and want to move on to February's data.

I copy Jansales.xls to Febsales.xls and copy Jangas.xls
to Febgas.xls.

When I go into the Febsales.xls to change my Jangas.xls
pointers to Febgas.xls pointers, They still have the
Jangas.xls name in the pointer field.

It's like because that was the original name of the
spreadsheet, for some reason, it needs to keep that
original name as a reminder where it's desendent's came
from.

Rather than reading febgas.xls!d10 it reads
[febgas]jangas.xls!d10.

Is there any way to get rid of the jangas.xls in this
cell reference?

If not, why does it need this?

Thanks for your help.
 
Are you sure you get this:
[febgas]jangas.xls!d10

I would have expected:
[febgas.xls]jangas!d10

The stuff in the [] brackets should be the workbook name. The stuff before the
exclamation mark should be the worksheet name.

And this isn't an answer, but have you thought of putting both the Store and
Sales in the same workbook.

Heck, maybe all the store's and all the sales (for all the months) could go in
on workbook.

It might make things a lot easier (organizationwise, at least).

Hello,

Here's an example of the problem.

Let's say I have a store that sells gasoline.

I want to record my store sales, and gasoline sales
in gallons.

So, I have a spreadsheet for store sales and a spreadsheet
for gas sales in gallons.

And these are setup per month. January sales sheets,
February sales sheets, etc.

I have the gas gallons spreadsheet linked to the stores
sales spreadsheet, so I can enter all the data while in
the sales spreadsheet.

Let's say I have entered all of January's sales and gas
data and want to move on to February's data.

I copy Jansales.xls to Febsales.xls and copy Jangas.xls
to Febgas.xls.

When I go into the Febsales.xls to change my Jangas.xls
pointers to Febgas.xls pointers, They still have the
Jangas.xls name in the pointer field.

It's like because that was the original name of the
spreadsheet, for some reason, it needs to keep that
original name as a reminder where it's desendent's came
from.

Rather than reading febgas.xls!d10 it reads
[febgas]jangas.xls!d10.

Is there any way to get rid of the jangas.xls in this
cell reference?

If not, why does it need this?

Thanks for your help.
Click to expand...
 
Back
Top