+ Reply to Thread
Results 1 to 3 of 3

An issue regarding the formula

  1. #1
    Registered User
    Join Date
    12-07-2005
    Posts
    4

    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

  2. #2
    Registered User
    Join Date
    12-07-2005
    Posts
    4
    Can anyone help on this?

    Thks & Rgds,
    HuaMin

  3. #3
    Dave Peterson
    Guest

    Re: An issue regarding the formula

    You have other replies at your other thread.

    But a couple of questions...

    Are both workbooks open in the same instance of excel (do you see both names
    under the Window option on the worksheet menu bar?)

    If you don't, then close one, and open it using File|open in that first
    instance.

    Are you copying from a filtered list?



    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...o&userid=29423
    > View this thread: http://www.excelforum.com/showthread...hreadid=491346


    --

    Dave Peterson

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1