Home

Formulas not working after Copy/Paste

%3CLINGO-SUB%20id%3D%22lingo-sub-393369%22%20slang%3D%22en-US%22%3EFormulas%20not%20working%20after%20Copy%2FPaste%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-393369%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20spread%20sheet%20that%20keeps%20track%20of%20my%20rental%20properties.%20If%20my%20property%20manager%20fills%20a%20vacant%20unit%20within%2030%20days%2C%20she%20gets%2010%25%20of%20the%20rent%20for%20that%20month%20as%20opposed%20to%207%25.%20Columns%20K%20and%20L%20are%20the%20ones%20where%20the%20property%20manager%20puts%20the%20move%20in%20and%20move%20out%20date.%20Based%20off%20the%20formulas%20in%20column%20P%20and%20Q%2C%20Column%20M%20will%20recognize%20if%20the%20date%20range%20that%20was%20input%20is%2030%20days%20or%20less%20and%20read%20%22TRUE%22%20if%20it%20is%20and%20%22FALSE%22%20if%20it%20is%20more%20than%2030%20days.%20The%20cell%20right%20above%2C%20in%20column%20M%2C%20is%20conditioned%20to%20calculate%20the%203%25%20additional%20bonus%20if%20it%20is%20%22TRUE%22.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20problem%20is%20that%20when%20I%20copy%20the%20sheet%20and%20paste%20it%20for%20the%20next%20month%2C%20these%20formulas%20don't%20work%20anymore.%20I've%20made%20sure%20that%20the%20%22Workbook%20Calculation%22%20is%20set%20to%20automatic%20and%20not%20manual.%20I%20can%20not%20figure%20out%20how%20to%20make%20these%20formulas%20still%20work%20once%20pasted.%20Attached%20is%20the%20file.%20The%20tab%20titled%20%22Original%22%20is%20as%20it%20sounds%20and%20the%20second%20tab%20titled%20%22Pasted%22%20was%20simply%20pasted%20there%20and%20no%20longer%20works.%20Please%20help.%20Thank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-393369%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-408313%22%20slang%3D%22en-US%22%3ERe%3A%20Formulas%20not%20working%20after%20Copy%2FPaste%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-408313%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F312974%22%20target%3D%22_blank%22%3E%40stevenmiles%3C%2FA%3E%26nbsp%3B%2C%20you%20are%20welcome%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-408233%22%20slang%3D%22en-US%22%3ERe%3A%20Formulas%20not%20working%20after%20Copy%2FPaste%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-408233%22%20slang%3D%22en-US%22%3E%3CP%3ESergei%2C%20you%20are%20the%20freaking%20man!!%20Thank%20you%20so%20much%20for%20your%20help!!!%20That%20fixed%20it!%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-393375%22%20slang%3D%22en-US%22%3ERe%3A%20Formulas%20not%20working%20after%20Copy%2FPaste%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-393375%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F312974%22%20target%3D%22_blank%22%3E%40stevenmiles%3C%2FA%3E%20%2C%20you%20have%20links%20in%20your%20worksheet%20like%20this%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20196px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F101449i46FC4FD31CA66707%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EWhen%20you%20copy%20the%20sheet%20they%20are%20kept%20and%20your%20cells%20are%20linked%20to%20the%20original%20sheet.%20From%20here%20you%20may%20Ctrl%2BH%20and%20replace%20Original!%20on%20Pasted!%3C%2FP%3E%3C%2FLINGO-BODY%3E
stevenmiles
New Contributor

I have a spread sheet that keeps track of my rental properties. If my property manager fills a vacant unit within 30 days, she gets 10% of the rent for that month as opposed to 7%. Columns K and L are the ones where the property manager puts the move in and move out date. Based off the formulas in column P and Q, Column M will recognize if the date range that was input is 30 days or less and read "TRUE" if it is and "FALSE" if it is more than 30 days. The cell right above, in column M, is conditioned to calculate the 3% additional bonus if it is "TRUE". 

 

The problem is that when I copy the sheet and paste it for the next month, these formulas don't work anymore. I've made sure that the "Workbook Calculation" is set to automatic and not manual. I can not figure out how to make these formulas still work once pasted. Attached is the file. The tab titled "Original" is as it sounds and the second tab titled "Pasted" was simply pasted there and no longer works. Please help. Thank you!

3 Replies

@stevenmiles , you have links in your worksheet like this

image.png

When you copy the sheet they are kept and your cells are linked to the original sheet. From here you may Ctrl+H and replace Original! on Pasted!

Sergei, you are the freaking man!! Thank you so much for your help!!! That fixed it!@Sergei Baklan 

@stevenmiles , you are welcome

Related Conversations
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies