Copying Spreadsheets without referencing other workbook.

M

monahmat

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
 
S

shail

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
 
S

shail

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

hi,

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

hth
regards from Brazil
Marcelo

"[email protected]" 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
Click to expand...
Click to expand...
 
M

monahmat

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!
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



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
Click to expand...
Click to expand...
 
M

monahmat

Thank you Shail and Marcelo, the find and replace worked. That was so
simple I never even thought about it. Thank you once again.
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!
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



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
Click to expand...
Click to expand...
Click to expand...
 
M

Marcelo

you are welcome thanks for the feedback

regards

"[email protected]" 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.
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!
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



[email protected] 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
Click to expand...
Click to expand...
Click to expand...
 
M

Marcelo

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

hi,

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

hth
regards from Brazil
Marcelo

"[email protected]" 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
Click to expand...
Click to expand...
Click to expand...
 
S

shail

Thanks Marcelo

Shail
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

hi,

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

hth
regards from Brazil
Marcelo

"[email protected]" 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
Click to expand...
Click to expand...
Click to expand...
 
Top