Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-13-2012, 02:21 PM
sandsoppa sandsoppa is offline formula lost when copied between files Windows 7 formula lost when copied between files Office 2010 (Version 14.0)
Novice
formula lost when copied between files
 
Join Date: Oct 2010
Posts: 8
sandsoppa is on a distinguished road
Unhappy formula lost when copied between files

when I pasted a group of copied cells with formula in from one file to another (opened by two Excel programs windows at same time). all formula disappeared. just like "paste special-value only". When i checked the menu of "paste special", there was no options but "HTML/Unicode/text". Can anyone help me to find out how to get the cells in one file pasted to another under a different window without losing the formula? Thanks in advances,

sandy,

Last edited by sandsoppa; 02-13-2012 at 07:07 PM.
Reply With Quote
  #2  
Old 02-14-2012, 02:33 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline formula lost when copied between files Windows XP formula lost when copied between files Office 2003
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

I think it should work if you open the wbks in the same XL instance
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #3  
Old 02-14-2012, 10:38 AM
sandsoppa sandsoppa is offline formula lost when copied between files Windows 7 formula lost when copied between files Office 2010 (Version 14.0)
Novice
formula lost when copied between files
 
Join Date: Oct 2010
Posts: 8
sandsoppa is on a distinguished road
Default

thanks for your answer.
the problem is that i use two screens, it is not convenient to stretch the window all way across two screens. In addition, every time a new workbook was open, it takes the two full screens and i have to re-size it in order to work on multiple workbooks side by side. That is why i like work with two Excel windows, each in one screen.

sandy
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Underlined copied text box LarryStroup PowerPoint 0 09-30-2011 11:22 AM
formula lost when copied between files Hyperlinks across DOC files lost in PDF conversion melinda Word 3 05-31-2011 05:03 PM
Formula not getting copied to entire column theacegary Excel 1 11-29-2010 02:18 PM
formula lost when copied between files Word Doc Copied from HTML Pat801 Word 2 03-30-2010 01:37 PM
Help please-lost files buffbenj Outlook 0 06-25-2007 06:53 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:00 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft