<div>
Maybe the destination cell is formated as a &quot;Text&quot;. If yes, try &quot;General&quot; that should work.<br />
<br />
Hope this helps.
</div>


Maybe the destination cell is formated as a "Text". If yes, try "General" that should work.

Hope this helps.

<div>
Skype was the problem. &nbsp;Thanks
</div>


<div>
<div class="content wysiwyg-content">
Data is exported from forecasting software into Excel 07. &nbsp;Once in there a formula has been created for one cell. &nbsp;When it is copied and pasted into another cell it will not paste the formula on the sum of the formula. &nbsp;If the + is used to drag across the formula is copied across. &nbsp;<br />
<br />
When right click paste special is tried the only options are as shown below:<br />
&nbsp;<a href="https://filedb.experts-exchange.com/incoming/2012/04_w16/569145/image001.png" target="_blank" title="Paste Special Message (15 KB)"><img alt="Paste Special Message" class="file-block lazyload" style="max-width: 527px;" data-src="https://filedb.experts-exchange.com/incoming/2012/04_w16/569145/image001.png" /></a><br />
It acts like the formula is being copied from multiple spreadsheets or workbooks when it is coming from the same spreadsheet. &nbsp;He is making sure the entire page is set to Automatically calculate and General format.<br />
<br />
The spreadsheet that will not copy formulas was sent to another person and they were able to get the formulas to work on their machine. &nbsp;It was sent back to him and worked on his machine after being formatted on another computer.<br />
<br />
What could be causing this?
</div>
</div>


image001.png

Data is exported from forecasting software into Excel 07.  Once in there a formula has been created for one cell.  When it is copied and pasted into another cell it will not paste the formula on the sum of the formula.  If the + is used to drag across the formula is copied across.  

When right click paste special is tried the only options are as shown below:
 

It acts like the formula is being copied from multiple spreadsheets or workbooks when it is coming from the same spreadsheet.  He is making sure the entire page is set to Automatically calculate and General format.

The spreadsheet that will not copy formulas was sent to another person and they were able to get the formulas to work on their machine.  It was sent back to him and worked on his machine after being formatted on another computer.

What could be causing this?

Excel 2007 won't copy formulas

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.