An issue regarding the formula

Hi, 
It's OK to copy the formula from one cell to another one within the
same sheet. How about that to copy the formula from one Excel file to
another one? It seems only the value of that cell will be copied to
that file but not the formula inside it. I even have tried to copy the
corr. formula within that again but just* the copied formula will not
work successfully in there. *

Thks & Rgds,
HuaMin


-- 
HuaMin
------------------------------------------------------------------------
HuaMin's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29423
View this thread: http://www.excelforum.com/showthread.php?threadid=491342

0
12/7/2005 4:25:19 AM
excel 39879 articles. 2 followers. Follow

2 Replies
443 Views

Similar Articles

[PageSpeed] 0

It should copy the formula from one workbook to another.

-- 

HTH

RP
(remove nothere from the email address if mailing direct)


"HuaMin" <HuaMin.1znk7y_1133929800.9013@excelforum-nospam.com> wrote in
message news:HuaMin.1znk7y_1133929800.9013@excelforum-nospam.com...
>
> Hi,
> It's OK to copy the formula from one cell to another one within the
> same sheet. How about that to copy the formula from one Excel file to
> another one? It seems only the value of that cell will be copied to
> that file but not the formula inside it. I even have tried to copy the
> corr. formula within that again but just* the copied formula will not
> work successfully in there. *
>
> Thks & Rgds,
> HuaMin
>
>
> -- 
> HuaMin
> ------------------------------------------------------------------------
> HuaMin's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=29423
> View this thread: http://www.excelforum.com/showthread.php?threadid=491342
>


0
bob.phillips1 (6510)
12/7/2005 8:56:22 AM
If it's not calculating correctly, make sure you're in autocalculation mode
(tools|Options|calculation tab).

If that's not the problem, you may want to post the troublesome formula and how
you're copy|pasting it.

HuaMin wrote:
> 
> Hi,
> It's OK to copy the formula from one cell to another one within the
> same sheet. How about that to copy the formula from one Excel file to
> another one? It seems only the value of that cell will be copied to
> that file but not the formula inside it. I even have tried to copy the
> corr. formula within that again but just* the copied formula will not
> work successfully in there. *
> 
> Thks & Rgds,
> HuaMin
> 
> --
> HuaMin
> ------------------------------------------------------------------------
> HuaMin's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29423
> View this thread: http://www.excelforum.com/showthread.php?threadid=491342

-- 

Dave Peterson
0
petersod (12005)
12/7/2005 2:44:05 PM
Reply:

Similar Artilces:

Multiple Table Join Issue
In a payroll system there are 4 tables One to many relationship Check Summary (cs) - Master Hours & Earnings (h&e) Taxes (t) Deductions (d) Query = Select cs.lastname, cs. firstname, cs.middlename, cs.clockno, cs.paydate, cs.payperiod, he.paycodedescript, he.paycode, he.currentearnings, t.taxdescript, t.currenttax, d.deductdescript, d.currentdeduct right join cs on cs.csid = he.linktocsid right join t.linktocsid = cs.csid right join d.linkto csid = cs.csid where cs.paydate >=(start of date range) and cs.paydate <=(end of date range) The result looks like this regpay...

formulas not dragging
In the past couple of months we have had problems with two of our spreadsheets used for payroll. These are spreadsheets that are duplicated and used each week for hours and such. For some reason the formulas won't drag. If you try to drag a formula for totalling columns, the value of the source cell appears instead of the total for each column. We are on a network with two computers using 2000 and one computer using 2002. What is more odd about this is we can go back into prior years in different directories and that particular spreadsheet has the same problem. This happene...

Formula Error #5
Hi, I have a spreadsheet, one sheet per month (ie November, December etc), which has this formula to calculate the daily average of sales (column P, and column U is for account sales, of which there may be not be any for the month), AVERAGE(IF(P10:P70>0,(P10:P70)+(U10:U70))) CTRL+SHIFT+ENTER. This is in cell F72, one row per day, and the >0 part of the formula is there so that future days are not calculated. I have a summary page for this current financial year, and each month contains this formula in cells B6,B8,B10 - B28: ='NOVEMBER 07'!F72 (as per it's month), how...

Help Im a nOOb. cell formulas.
Ok can you walk me through this I am very new to this. I have sheet 1. I have a starting balance on cell H1. Also on that sheet I have a Total on cell D3. Sheet 2 Column E will be my Recieved and Column G will be my paid. I dont know what the sum column is for. I need to have any number entries on Column E sheet 2 added to D3 sheet 1, and subtract from H1 sheet 1. Example: I have starting balance of $1000 in H1. And a Total on D3 of $500. I add $20 to any cell in Column E. We will say E2. Now H1 equals $980, E2 equals $20, and D3 equals $520. I barely know where to start so please be pat...

Troubleshooting issues with Excel
I couldn't find Excel Troubleshooting section thus decided to post my question in Excel section. Currently couple of my power users who use Office 2007 Enterprise Edition w/SP1 applied and all the patches started experience problems with Excel. Both will work with Excel in normal fashion and than, after few hours of work all of the sudden program has a screen redraw style issue. Menu options disappear and so on. So the excel window remain open but where the tool bar options are there is just blue space. When you close excel the menu that opens to ask you to save your program also...

Time formulas #3
Hello, I would like assistance with a "simple" time formula. a b 1 9:15:00 9:20:05 The formula I tried to use was "=a1-b1" but no luck. Suggestions would be appreciated. Thanks & Cheers Negative times display as ######## in the 1900 date system. If you want see negative times, you can change to the 1904 date system (Tools/Options/Calculation). For more, see http://cpearson.com/excel/datetime.htm#AddingTimes In article <FE47C4C5-BA28-4C3F-A224-D06929F8BCAA@microsoft.com>, "edver" <edver@discussions.microso...

Help! Formula needed.
Below is an example of data in my excel sheet. A B C D E F Cell 1 ? cell 2 Steve 1 to 10 13/2/04 britain cell 3 Raj 11 to 17 15/2/04 india cell 4 Ricky 18 to 35 14/2/04 Spain Now if i enter a numerical value in A1 (where '?' is), i need a formula which will check the column B and produce a result as desired below Entery number = 9 then print "Steve 1 to 10 13/2/04 britain" Entery number = 12 then print "Raj 11 to 17 15/2/04 india" Ente...

Formula Help #19
> The below formula was provided for the question below, can someone tell me how to add into the formula how to not include cells missing information so that it does take those cells into account when calculating the average in cell C1? =SUMIF(A1:A7,"Active",B1:B7)/COUNTIF(A1:A7,"Active") I have a question that I hope someone can help with. > > A B C > 1 ACTIVE 11.88% _______ Average > 2 ACTIVE 3 ACTIVE 12.80% > 4 ACTIVE 5 ACTI...

Video Issues
Hello and thanks for your help in advance. I am having an issue with the dos version of great plains. This is on a windows 98 machine. The program works fine but whenever you go to exit it messes up the screen on the top and bottom. The only way to clear it out is to reboot the pc. The latest video driver is installed on the pc. It is an integrated video card on an MSI motherboard. Thanks again for your help! Have a great day! Chad >-----Original Message----- >Hello and thanks for your help in advance. I am having >an issue with the dos version of great plains. Th...

Data Source Issues After Moving ReportServer DB to new server
Our report developers had created RDLs and posted to Report Manager. Then in Report Manager, reports data source is changed to point to a single new datasource set up in Report Manager. Now we have migrated Report Server database to new server using backup\restore (not RSScripter) but reports now generate error An error has occurred during report processing. Cannot create a connection to data source 'XXX'. The XXX data source is seen in the .rdl file. It seems that reports revert back to data source that was set up when developers designed reports in BIDS. Is ...

AND formula
Below is my example. I am not able to find any solution for AND fomula. My problem is in cell A, the figure entered is 42. I want this figure to show in Cell D. in other words, how can I create a fomula that determine if cell A is between 31 and 45, mark X (in cell D) A B C D E F -------------|---------|--------|---------|--------|---------- | <15 | 16-30 | 31-45 | 46-60 | >1 -------------|---------|--------|---------|--------|---------- 42 X ...

Pivot table segregation issue
I have data in lists and I am having intermitant problems with my pivot table differenciating on somehting I can not see. When I do a filter on a list I get no problems. But whne I do a pivot table on the same data it sometimes splits it up. For example I might have 12 cells in a column with "#2BR" in them. 10 will be in one pivot table group and then for no visable reason I get 2 of the 12 in to another group visually they look the same. whats up. thanks todd Thanks anyway but I found the problem I think! Apparently there is some unvisible to the eye leading and trai...

Formula Problem #14
When I drag and drop a formula it is copying the cells only and not the result, however when I go into the cell and press enter the result is correct. Tools|Options|Calculate If Manual is checked, change it to Automatic. Jerry Tracey BVS wrote: > When I drag and drop a formula it is copying the cells only and not the > result, however when I go into the cell and press enter the result is > correct. Hi goto 'Tools - Options - Calculate' and enable 'Automatic calculation' -- Regards Frank Kabel Frankfurt, Germany "Tracey BVS" <Tracey BVS@discuss...

Formula to delete row when cell contains "Y"
Hi, Column J can contain either "" or "Y". When J contains "Y" I want to delete the contents of columns A:J in that row only. Is this possible using only a formula rather than a macro? ...

Array (CSE) formulas
I am trying to understand array formulas, which I understand are sometimes also called CSE (Ctrl-Shift-Enter) formulas. I found some online tutorials, but am having trouble understanding some of it. This site, gives an example of using array formulas to calculate subtotals and totals. http://office.microsoft.com/en-us/excel/HA010872901033.aspx I cannot see that the array formula solution offers much of an advantage over a more typical solution. Here's a simplified version of the example above: A B C D 1 M N {MxN} MxN 2 1 2 2 2 3 2 3 6 ...

words as data for formula or chart
How can i crate a chart that would use words as data so basically the charts formula would count words in column to output value for example: I have a column where there are words: YES, NO, MAYBE etc... (all in one column) and I like on the chart to show that there are so many words YES, so many words NO, so many words MAYBE etc... in that column.. It could show a bar besically the longest means there is the most of these words ets... Is it possible? Thanks You can create a pivot table from the list, to get a quick summary of the data: Add a heading to the top of the list (e.g....

Excel Rows and Columns Issue
Thanks Anne, I haven't tried it, but I know it will do the trick. Thanks again! Cheers -- nexceluse ----------------------------------------------------------------------- nexceluser's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1507 View this thread: http://www.excelforum.com/showthread.php?threadid=26712 ...

Help with Federal Income tax formula!
I created some kind of form but doesn't know how to continue....I thin it has something to do with Min and Max :mad -- Outlawdevi ----------------------------------------------------------------------- Outlawdevil's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1667 View this thread: http://www.excelforum.com/showthread.php?threadid=31890 This forum will handle an Excel Min/Max issue. Can you provide more specifics about the data and what is or is not working? Dennis "Outlawdevil" wrote: > > I created some kind of form but doesn't...

Read Only Issue
Hello, I have a database that sits on a server. It is randomly opening in a Read Only state and provides a message when opening stating just that. Obviously the users aren't able to add/update data when this happens. Any idea how to make it stop? Appreciatively yours, ~ Chris 1. All users of the database must have read, write, create, and delete privileges to the network folder holding the database file. Not just the database .mdb file, but the entire folder. 2. Open the database and go to Tools, Options, and Advanced Tab. Set the Default Open mode to Shared and the Default Recor...

Outlook 2003 issues w/POP & Network Solutions
I've got a WinXPHome - all up to date. Outlook 2003 - all up to date. Norton Internet Security 2006 - disabled (as far as I can tell) - this was my first thought of being an issue POP mail with Network Solutions has issues sending and receiving. I've adjusting to port 2525 for outgoing and switched back & forth on that. No SSL. If I telnet to mail.domain.com 25 or 2525 no repsonse. I can setup another POP mail account (to my own Exchange 2003 server) and it works fine. I can change the outgoing mail server to an sbcglobal.net and mail will go out - but still encounter issue...

delete values in several cells without deleting the formulas
I wanted to clear the values in a spreadsheet without deleting the formulas or formatting in the spreadsheet. For example: A budget sheet made for every year, the formulas and formatting remains the same, only the values change. I tried paste special formulas....in this case, if values are present, they get copied too. Hi you can't delete the 'values' from a formula. The formula will always calculate its result -- Regards Frank Kabel Frankfurt, Germany "dranreb" <dranreb@discussions.microsoft.com> schrieb im Newsbeitrag news:43255A99-86BA-45A5-BB09-FCAEC002A09...

Regarding Update Resource Problem
Hi All, Actually i have some problems in putting back the extracted resources form an exe using the UpdateResource function. I could extract all the contents of the dialog resource from the exe.I was just trying to update them back to the exe facing some problems in it.Here is the list of steps we have followed . 1.LoadLibrary -> Map the specified executable module into the address space of the calling process. 2.EnumResource -> Check for the list of available resource 3.FindResource -> Find the specified resource. 4.LoadResource -> Load specified resource into globa...

DPM issue when use remote Name instace of SQLon diferent port
Hi all I just want to install SCDPM on one server, all prerequisites pass fine, I'm use a remote instance of SQL 2005 My SQL server have two instances: * MSSQLSERVER (default) SQL server 2008 port 1433 *MSSQL05 SQL Server 2005 port 1466 I'm use servername\MSSQL05 and correct user-password-Domain or servername\MSSQL05:1466 and get the following errors: "DPM Setup is unable to conect to the specified instance of SQL server. (ID 4307) Verify that the spesified computer and the instance of SQL server meets the followings requierements: 1)The computer is acc...

Autocomplete issue
Hello all, I'm currently trying to think of a way to work around the problem tha Excel's autocomplete tool breaks a column's autocomplete "memory" afte several empty cells. Does anybody know a way to keep all the column's autocomplete entrie available when you start entering data into cells further down th column, after leaving several with no-data cells. Any help would be much appreciated Thanks, Georg -- George ----------------------------------------------------------------------- GeorgeC's Profile: http://www.excelforum.com/member.php?action=getinfo&...

2007 Contact Category issues
This is a strange one---one of my (computer-savvy) students called and wanted to know why when she categorized her contacts she could see that they are in the correct category individually-----but when she clicks on Category View they don't all show up. She had one particular category that had 44 people----but in Category View only SIX showed up..... Does ANYONE have an idea what could cause this? We did a work-around of creating a separate folder for that group---but that is not really the proper answer. I have used this site many times to get tricky answers and have bee...