Calculation Issues

How to Stop Excel Paste Values from Recalculating RAND Formulas

Natalie Taylor Sep 30, 2026 869 views

Question details

The user needs a way to paste values in an Excel spreadsheet without triggering the recalculation of volatile formulas like RAND.

How to Prevent Excel Paste Values from Recalculating RAND Formulas

Product: Microsoft Excel
Device & OS: not provided
Scenario: Copying data and using the Paste Values command in a workbook that contains volatile formulas.
Observed behavior: Selecting the Paste Values option from the ribbon or context menu forces volatile formulas to recalculate unexpectedly.

Before you start

Check your Microsoft 365 update status under File > Account to ensure you are running the latest version, as Microsoft frequently patches calculation triggers. If you plan to use the macro workaround, confirm that your Trust Center settings allow you to run custom macros.

Solution 1Recommended

Use Paste Special Keyboard Shortcuts

Bypass the graphical user interface (ribbon and context menu) by using native Excel keyboard shortcuts to paste values, which avoids triggering the recalculation event.

Excel sometimes interprets clicks on the ribbon or context menus as application-level events, which forces volatile formulas to recalculate. Using keyboard shortcuts circumvents these UI triggers.

Copy the data

Highlight the cells you want to copy and press Ctrl + C on your keyboard.

Open the Paste Special dialog

Select the destination cell where you want to paste the data, then press Ctrl + Alt + V to open the Paste Special window.

Select the Values option

Press the 'V' key to quickly select the 'Values' radio button, then press Enter or click OK to complete the paste.

Alternative Shortcut: Depending on your Excel version, you can also use the sequential shortcut Alt, H, V, V to paste values directly without opening the dialog box.

Solution 2

Create a Custom VBA Macro for Pasting Values

Write a short VBA macro that pastes only values and assign it to a custom keyboard shortcut to ensure volatile formulas are never triggered.

Try WPS Spreadsheet

Paste Values Without Recalculation Bugs in WPS Office

Avoid unpredictable calculation triggers by using WPS Spreadsheet. WPS Office offers a stable, lightweight environment to handle complex formulas and data processing tasks seamlessly.

1. Download and Install WPS Office: Visit the official WPS website to download and install WPS Office for free on your device.
2. Open your Workbook: Launch WPS Spreadsheet and open your existing Microsoft Excel (.xlsx) file containing the volatile formulas.
3. Copy the Target Data: Select the data range you wish to duplicate and press Ctrl + C to copy it to your clipboard.
4. Paste as Values: Right-click the destination cell and directly choose 'Paste as Values' (or use the Paste Special menu) to insert the data without unintended recalculations.

Fully compatible with Microsoft Excel formats (.xlsx, .xls, .csv)Stable clipboard operations that respect your manual calculationsFree and lightweight alternative to heavy office suitesFamiliar ribbon interface with zero learning curve

Frequently Asked Questions

Why do volatile formulas like RAND recalculate when pasting?

Volatile formulas (such as RAND, TODAY, and NOW) are designed by Microsoft Excel to recalculate every time any change is made to the worksheet. Certain UI interactions, like clicking 'Paste Values' on the ribbon, trigger an application-level event that forces a recalculation before the operation finishes.

Can I turn off automatic calculation temporarily?

Yes. You can go to the Formulas tab on the ribbon, click 'Calculation Options', and select 'Manual'. This stops all formulas in the workbook from recalculating until you press F9 or switch the setting back to 'Automatic'.

What is the difference between 'Keep Text Only' and 'Paste Values'?

'Paste Values' pastes the calculated results of formulas or pure data while maintaining Excel's cell grid context. 'Keep Text Only' strips all formatting and attempts to convert clipboard data into plain text. 'Keep Text Only' may be disabled depending on the source application and destination.

Excel & Data Problems