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?
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?
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?
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
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?
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?
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.
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 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.
Sometimes Excel tries to help us TOO much.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks