Copying Spreadsheets without referencing other workbook.
 

I have two workbooks and would like to copy a page from Workbook A into
Workbook B. However when I do this the page I copy always references
Workbook A in the formulas. Is there any way to copy a sheet without
this happening?

example: formulas look like =[WorkbookA.xls]Data!D11
- I don't want the [WorkbookA.xls] included after copying, it should
just read Data!D11. There is already a sheet in the new workbook
titled Data that I would like it to point to.

Any help would be greatly appreciated!

Matt

Copying Spreadsheets without referencing other workbook.
 

Hi Matt,

If what I exactly understood by your question.

Do not copy from where the name of the worksheet appears. Select all
(Crtl+A) the Worksheet A and Copy all the cells. Open Worksheet B.
Right click your mouse button at A1 of the Worksheet B and click Paste
Special and select "Values" option.

This might help you.

Thanks,

Shail



wrote:

I have two workbooks and would like to copy a page from Workbook A into
Workbook B. However when I do this the page I copy always references
Workbook A in the formulas. Is there any way to copy a sheet without
this happening?

example: formulas look like =[WorkbookA.xls]Data!D11
- I don't want the [WorkbookA.xls] included after copying, it should
just read Data!D11. There is already a sheet in the new workbook
titled Data that I would like it to point to.

Any help would be greatly appreciated!

Matt

Copying Spreadsheets without referencing other workbook.
 

hi,

copy and after replace =[workbooka.xls] per =

hth
regards from Brazil
Marcelo

" escreveu:

I have two workbooks and would like to copy a page from Workbook A into
Workbook B. However when I do this the page I copy always references
Workbook A in the formulas. Is there any way to copy a sheet without
this happening?

example: formulas look like =[WorkbookA.xls]Data!D11
- I don't want the [WorkbookA.xls] included after copying, it should
just read Data!D11. There is already a sheet in the new workbook
titled Data that I would like it to point to.

Any help would be greatly appreciated!

Matt

Copying Spreadsheets without referencing other workbook.
 

Hi,

Marcelo has good option for you.

You can Replace (Ctrl+H)

[WorkbookA.xls] with a null value for all the cells so you won't get
WorkbookA.xls before any of you functions.

Thanks Marcello to you too.

Shail


Marcelo wrote:

hi,

copy and after replace =[workbooka.xls] per =

hth
regards from Brazil
Marcelo

" escreveu:

I have two workbooks and would like to copy a page from Workbook A into
Workbook B. However when I do this the page I copy always references
Workbook A in the formulas. Is there any way to copy a sheet without
this happening?

example: formulas look like =[WorkbookA.xls]Data!D11
- I don't want the [WorkbookA.xls] included after copying, it should
just read Data!D11. There is already a sheet in the new workbook
titled Data that I would like it to point to.

Any help would be greatly appreciated!

Matt

Copying Spreadsheets without referencing other workbook.
 

I'm sorry I may not have been clear. I'm trying to copy a sheet from
one workbook to another. But when I do so all my cell references point
to the other workbook. I want to keep the references just eliminate
the references to the other workbook. Thanks!

shail wrote:
Hi Matt,

If what I exactly understood by your question.

Do not copy from where the name of the worksheet appears. Select all
(Crtl+A) the Worksheet A and Copy all the cells. Open Worksheet B.
Right click your mouse button at A1 of the Worksheet B and click Paste
Special and select "Values" option.

This might help you.

Thanks,

Shail



wrote:

I have two workbooks and would like to copy a page from Workbook A into
Workbook B. However when I do this the page I copy always references
Workbook A in the formulas. Is there any way to copy a sheet without
this happening?

example: formulas look like =[WorkbookA.xls]Data!D11
- I don't want the [WorkbookA.xls] included after copying, it should
just read Data!D11. There is already a sheet in the new workbook
titled Data that I would like it to point to.

Any help would be greatly appreciated!

Matt

Copying Spreadsheets without referencing other workbook.
 

Thank you Shail and Marcelo, the find and replace worked. That was so
simple I never even thought about it. Thank you once again.
wrote:
I'm sorry I may not have been clear. I'm trying to copy a sheet from
one workbook to another. But when I do so all my cell references point
to the other workbook. I want to keep the references just eliminate
the references to the other workbook. Thanks!

shail wrote:
Hi Matt,

If what I exactly understood by your question.

Do not copy from where the name of the worksheet appears. Select all
(Crtl+A) the Worksheet A and Copy all the cells. Open Worksheet B.
Right click your mouse button at A1 of the Worksheet B and click Paste
Special and select "Values" option.

This might help you.

Thanks,

Shail



wrote:

I have two workbooks and would like to copy a page from Workbook A into
Workbook B. However when I do this the page I copy always references
Workbook A in the formulas. Is there any way to copy a sheet without
this happening?

example: formulas look like =[WorkbookA.xls]Data!D11
- I don't want the [WorkbookA.xls] included after copying, it should
just read Data!D11. There is already a sheet in the new workbook
titled Data that I would like it to point to.

Any help would be greatly appreciated!

Matt

Copying Spreadsheets without referencing other workbook.
 

you are welcome thanks for the feedback

regards

" escreveu:

Thank you Shail and Marcelo, the find and replace worked. That was so
simple I never even thought about it. Thank you once again.
wrote:
I'm sorry I may not have been clear. I'm trying to copy a sheet from
one workbook to another. But when I do so all my cell references point
to the other workbook. I want to keep the references just eliminate
the references to the other workbook. Thanks!

shail wrote:
Hi Matt,

If what I exactly understood by your question.

Do not copy from where the name of the worksheet appears. Select all
(Crtl+A) the Worksheet A and Copy all the cells. Open Worksheet B.
Right click your mouse button at A1 of the Worksheet B and click Paste
Special and select "Values" option.

This might help you.

Thanks,

Shail



wrote:

I have two workbooks and would like to copy a page from Workbook A into
Workbook B. However when I do this the page I copy always references
Workbook A in the formulas. Is there any way to copy a sheet without
this happening?

example: formulas look like =[WorkbookA.xls]Data!D11
- I don't want the [WorkbookA.xls] included after copying, it should
just read Data!D11. There is already a sheet in the new workbook
titled Data that I would like it to point to.

Any help would be greatly appreciated!

Matt

Copying Spreadsheets without referencing other workbook.
 

thanks for the feedback Shail

regards from Brazil
Marcelo

"shail" escreveu:

Hi,

Marcelo has good option for you.

You can Replace (Ctrl+H)

[WorkbookA.xls] with a null value for all the cells so you won't get
WorkbookA.xls before any of you functions.

Thanks Marcello to you too.

Shail


Marcelo wrote:

hi,

copy and after replace =[workbooka.xls] per =

hth
regards from Brazil
Marcelo

" escreveu:

I have two workbooks and would like to copy a page from Workbook A into
Workbook B. However when I do this the page I copy always references
Workbook A in the formulas. Is there any way to copy a sheet without
this happening?

example: formulas look like =[WorkbookA.xls]Data!D11
- I don't want the [WorkbookA.xls] included after copying, it should
just read Data!D11. There is already a sheet in the new workbook
titled Data that I would like it to point to.

Any help would be greatly appreciated!

Matt

Copying Spreadsheets without referencing other workbook.
 

Thanks Marcelo

Shail

Marcelo wrote:
thanks for the feedback Shail

regards from Brazil
Marcelo

"shail" escreveu:

Hi,

Marcelo has good option for you.

You can Replace (Ctrl+H)

[WorkbookA.xls] with a null value for all the cells so you won't get
WorkbookA.xls before any of you functions.

Thanks Marcello to you too.

Shail


Marcelo wrote:

hi,

copy and after replace =[workbooka.xls] per =

hth
regards from Brazil
Marcelo

" escreveu:

I have two workbooks and would like to copy a page from Workbook A into
Workbook B. However when I do this the page I copy always references
Workbook A in the formulas. Is there any way to copy a sheet without
this happening?

example: formulas look like =[WorkbookA.xls]Data!D11
- I don't want the [WorkbookA.xls] included after copying, it should
just read Data!D11. There is already a sheet in the new workbook
titled Data that I would like it to point to.

Any help would be greatly appreciated!

Matt