+ Reply to Thread
Results 1 to 4 of 4

Excel formulas don't work on spread sheet...

  1. #1
    Registered User
    Join Date
    06-17-2014
    Location
    Male'
    MS-Off Ver
    Office 2010
    Posts
    31

    Excel formulas don't work on spread sheet...

    Hi,

    I have a file excel file on my pc and another excel file in my google drive.
    I have some formulas in drive excel file to extract some data from the file in my pc.

    The problem is once i close the file on my pc the formula in drive file does not work.
    I have attached an example.
    Attached Files Attached Files

  2. #2
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,651

    Re: Excel formulas don't work on spread sheet...

    Try changing your formula like below to see if that works for you....

    Please Login or Register  to view this content.
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

  3. #3
    Registered User
    Join Date
    06-17-2014
    Location
    Male'
    MS-Off Ver
    Office 2010
    Posts
    31

    Re: Excel formulas don't work on spread sheet...

    It works on drive file on my pc. But if i open it with browser it gives "#ERROR!" and when point mouse cursor on it it says "Formula parse error."

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,973

    Re: Excel formulas don't work on spread sheet...

    I dont use google docs, but I do know that the syntax of some of the formulas used there is very different from the native excel formulas - and some excel formulas are not even supported on google docs
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Spread sheet to work out Overdraft interest charges
    By Antoun in forum Excel General
    Replies: 0
    Last Post: 08-31-2015, 02:39 PM
  2. Will Macro work on a hidden spread sheet
    By schmidtpainting in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 12-16-2013, 04:39 PM
  3. Generating New Spread Sheets with Info from the very last work sheet
    By jasw529 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-28-2013, 08:52 AM
  4. Spread Sheet Formulas and Drop Down
    By sabreclaw in forum Excel General
    Replies: 34
    Last Post: 05-29-2008, 11:22 AM
  5. [SOLVED] How do I set up a spread sheet that will add my hours work in h:mm
    By Johnnyboy7444 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-17-2006, 04:10 AM
  6. [SOLVED] How can i keep formulas in a spread sheet when it is saved over?
    By saveas getting rid of formulas in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-17-2006, 04:50 PM
  7. [SOLVED] Function help:work in spread sheet
    By Derrell Roberts in forum Excel General
    Replies: 1
    Last Post: 08-12-2005, 07:05 PM

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