tkaplan
08-13-2014, 06:49 AM
Hi,
At work they have changed our systems of where we save files. All files are now saved in some software program, that when you open an excel file it always creates a new instance of excel. When I copy and paste a formula, I can't figure out how to carry the formula and formatting over.....it seems that it only allows me to paste values. Also, if I try to move or copy a worksheet to another workbook, the other workbook that I have opened in a different instance is not coming in as an option to move it to.
Is there any way to get excel to recognize that other excel workbooks are open?
TIA
T
At work they have changed our systems of where we save files. All files are now saved in some software program, that when you open an excel file it always creates a new instance of excel. When I copy and paste a formula, I can't figure out how to carry the formula and formatting over.....it seems that it only allows me to paste values. Also, if I try to move or copy a worksheet to another workbook, the other workbook that I have opened in a different instance is not coming in as an option to move it to.
Is there any way to get excel to recognize that other excel workbooks are open?
TIA
T