Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.

Windows 7: In Excel copy/paste not updating formula in a range

08 Apr 2016   #1

Windows 7 Ultimate x64
In Excel copy/paste not updating formula in a range

This started in win 7 and continues in win 10. After pasting into range shows original value in the entire range. This happens with Excel functions and VBA. The error can be easily corrected with search set to = and replace set to =. I would prefer correcting the problem. I frequently change formulas. Am running Enterprise 2010 of Office.

My System SpecsSystem Spec

 In Excel copy/paste not updating formula in a range

Thread Tools

Similar help and support threads
Thread Forum
Excel Formula
Hello Sir, Can you let me know the formula in Excel: I have a table as below: This table, At the column "A,Status" when i Put the word" Completed", it's will automatic put current Date to Column "B, Row 2". But i don't know after that when tomorrow arrived,at the column "B,Row 2",...
Microsoft Office
Annoying Excel Copy/Paste Problem
When I copy and paste a cell under Excel 2010 I get a small 'Ctrl' message below and to the right of the target cell -- the one I am pasting to. The message's drop down list contains all of the paste functions. The only way I can clear the message is to use ESC or copy another cell. I've lived...
Excel 2003 sum formula problem
I have been entering currency data in Column B in Euros to an EXCEL 2003 s/s and the formula used has added these totals entered in that Column correctly until I reached a total sum of 74364.70 Euros ,this being the sum of entries in Rows B6 to B82 . This was reached with the formula showing as...
Microsoft Office
Want to copy data and formula from one Excel Sheet to another.
I have a budget workbook set up in Excel, and in that workbook there are many different sheets all part of the one book. I have created a formula in one sheet from the data that is collected there, and that data is important for information collected on another sheet. I want to copy the...
Microsoft Office
Excel Formula Help please...
This is probably very simple and I have got it working but it isn't working how I want it to work. I have created an Excel document to show my monthly payments of a bank loan. I have created 3 columns in the first column is the payment number, in the second column is the amount that the loan...
Microsoft Office

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 10:16.
Twitter Facebook Google+