Copy sheet as is from workbook to another?

[Frigide]

When to people working on the same project at home and try to combine the result without messing up formules. Is it possible to copy a sheet from one workbook to another without changing any formules?

[dflak]

Do you want to copy the sheet to a new workbook or add it to an existing workbook? Also do you need to recombine the data?

Is it the same sheet all the time?

[Frigide]

This is getting a problem now. I work at home on a excel sheet for my work. I download parameters from PGIM at work. But the excel sheet i program/make at home. Today i added all the links for PGIM and it is working like a charm, i only had a few cosmetic errors. So i like to update/ upgrade the excel file at home. But when i open the file at home excel ''corrects" all the links. So when i'm at work in 2 days nothing is working anymore. Is there a way to open the file and leave all the links as is?

[dflak]

Let me see if I understand what is happening. You created the workbook at work and it is good. You take the workbook home and it is good - or at least you can do data entry on it. You take the workbook back to work and it doesn't work anymore. In what way does it not work? Do you have multiple error codes like #REF! or #Value! in the cells?

Without being able to see what the old and new links look like, I really can't help. Is there a way you could get a screen capture of the link the way it is supposed to be and then also post a sample workbook?

[Frigide]

Example! (not exact because i don't know the exact code because i'm at home.
This

(pgim_get_values('$PGIM_CONFI'!$C$28;"AVG";'$PGIM_CONFI'!$B$5;'$PGIM_CONFI'!$B$6;"PCLT";1;8;1;"1 h";;"0A")

Will become this when i open the file i copied at work to my google drive and opent it at home.

='C:\Users\myname\AppData\Microsoft\Excel\XLSTART\pgimreport.xlam'!pgim_get_values('$PGIM_CONFI'!$C$28;"AVG";'$PGIM_CONFI'!$B$5;'$PGIM_CONFI'!$B$6;"PCLT";1;8;1;"1 h";;"0A")

And when i make a sheet in a cope op a file and copy it to the origanal at work all the formules are changed.

[dflak]

Confirm for me. It works when you bring it home and work on it but does not work when you get back to work.

[Frigide]

Confirm for me. It works when you bring it home and work on it but does not work when you get back to work.

I'm not sure yet. I know it tomorrow in my night shift. When i ad something at home en open it at work again. Can the extra text leave when i open it in the correct network again??

I let you know.

[dflak]

I have no way to test this. Here is how I envision this working.

At work, put the sheet you want to work on in the same directory with this workbook. Enter the name of the workbook in Cell B1.

Confirm that the string in cell B3 is correct.

Click the Copy button. This will copy the workbook (sheet 1) into the New Sheet Sheet on this workbook.

Take this workbook home.

Work on New Sheet.

Take the workbook back to work.

Click on the Paste button. This should produce a new workbook with the links removed.

[Frigide]

I have no way to test this. Here is how I envision this working.

At work, put the sheet you want to work on in the same directory with this workbook. Enter the name of the workbook in Cell B1.

Confirm that the string in cell B3 is correct.

Click the Copy button. This will copy the workbook (sheet 1) into the New Sheet Sheet on this workbook.

Take this workbook home.

Work on New Sheet.

Take the workbook back to work.

Click on the Paste button. This should produce a new workbook with the links removed.

Thanks wil try. Will it work with several sheets from one workbook

[Frigide]

I have no way to test this. Here is how I envision this working.

At work, put the sheet you want to work on in the same directory with this workbook. Enter the name of the workbook in Cell B1.

Confirm that the string in cell B3 is correct.

Click the Copy button. This will copy the workbook (sheet 1) into the New Sheet Sheet on this workbook.

Take this workbook home.

Work on New Sheet.

Take the workbook back to work.

Click on the Paste button. This should produce a new workbook with the links removed.

Still i find it very strange that Excel don't give you a option to leave links an formules as is!! I dont want to change them. Leave them be on what ever computer open the workbook.

[dflak]

Sometimes Excel tries to help us TOO much.