+ Reply to Thread
Results 1 to 3 of 3

Unlink Formula - slow calculation

  1. #1
    Registered User
    Join Date
    05-03-2011
    Location
    Melbourne
    MS-Off Ver
    Excel 2003
    Posts
    1

    Unlink Formula - slow calculation

    Hi All,
    Let's say I have 2 xls file (test1.xls & test2.xls); and test1 file referring the value from test2 file

    TEST 1.xls
    Please Login or Register  to view this content.
    To do the above actions, I created a macro, but excel always frozen for couple of seconds during cell value set (.Cells(X, Y).FormulaR1C1 = tempvalue); as it will check the value from test2.xls
    Please Login or Register  to view this content.
    I've tried to unlink the file beforehand:
    Please Login or Register  to view this content.
    as well as
    Please Login or Register  to view this content.
    and
    Please Login or Register  to view this content.
    But no luck, it seems XLS keeps linking to that page everytime I put value (either manually / by macro)

    Any idea?, as it slows down my xls

    Thanks

  2. #2
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,324

    Re: Unlink Formula - slow calculation

    Hi televisi,
    what do you wish to accomplish?

  3. #3
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,646

    Re: Unlink Formula - slow calculation

    what's the value of x ?
    VBA is quite anaother language than Excle's formula-language
    In this example (your code translated) both workbooks have to be loaded.
    Please Login or Register  to view this content.
    PS. It seems rather complicated to use Hlookup in a range containing 76 columns, to return the value in the 124th column. : ' R2C8:R125C84,124 '
    Last edited by snb; 05-04-2011 at 05:13 AM.



+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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