Yes, there is a solution to your problem. It sounds like your Excel settings are set to paste values only instead of formulas. Here's how to change it:

1. Select the cell(s) with the formula(s) you want to copy.
2. Right-click and select "Copy" or use the keyboard shortcut "Ctrl + C".
3. Go to the destination workbook and select the cell(s) where you want to paste the formula(s).
4. Right-click and select "Paste Special" or use the keyboard shortcut "Ctrl + Alt + V".
5. In the "Paste Special" dialog box, make sure the "Formulas" option is selected.
6. Click "OK" to paste the formula(s) into the selected cell(s).

If you want to make this the default setting for all future paste special operations, follow these steps:

1. Click on the "Office" button in the top left corner of the Excel window.
2. Click on "Excel Options" at the bottom of the menu.
3. Click on "Advanced" in the left-hand menu.
4. Scroll down to the "Cut, copy, and paste" section.
5. Make sure the "Show Paste Options buttons" and "Cut, copy, and sort inserted objects with their parent cells" options are checked.
6. Under "Pasting within the same workbook", select "Formulas" as the default option.
7. Under "Pasting between workbooks", select "Keep Source Formatting" as the default option.
8. Click "OK" to save your changes.

Now, whenever you use the paste special function, it will default to pasting formulas instead of values.