General discussion

  • Creator
    Topic
  • #2297260

    Problem in Excel

    Locked

    by bcasselman ·

    When I past figures into cells that are used in a formula, it will not autosum. ie;
    if I have =A2+B2 in C2..when I past the A2 value, then it shows in C2 but when I past the value (from website) in B2 the C2 goes blank. I can CTrl D and it will fill in but one extra key stroke when I used this all day is frustrating.

All Comments

  • Author
    Replies
    • #2686746

      Reply To: Problem in Excel

      by dklippert ·

      In reply to Problem in Excel

      Please attempt to clarify your question.
      Where does Fill down (Ctrl+D) come in?
      What format is the value from website?

      • #2685909

        Reply To: Problem in Excel

        by bcasselman ·

        In reply to Reply To: Problem in Excel

        I only use (Ctrl+D) because C2 does not automatically fill in when I paste B2 value. I do not know the format of the values. I highlite and “copy” these off of a website that list columns of figures which I copy certain ones from the list. Sorry, I am not much help as I am new to excel. (work partime as an office assistant)

    • #2685257

      Reply To: Problem in Excel

      by pr0x1 ·

      In reply to Problem in Excel

      Do you have Autoupdate turned on? for tables? or is it manual? If you created the file and have auto as a default, this isn’t it, but if you didn’t create the file, then this might be turned off for tables.
      Tools – Options – Calculation

      Also try Clicking Refresh Data on the External Data toolbar.

      If your worksheet contains more than one external data range that you want to refresh, on the View menu, point to Toolbars, and click External Data.
      On the External Data toolbar, click Refresh All to refresh all of the external data ranges in the workbook.

      MAke sure you dont have security or a password preventing this.

    • #2686444

      Reply To: Problem in Excel

      by dklippert ·

      In reply to Problem in Excel

      Look at the contents of C2 after the paste. Also try putting the formula in another cell such as G2.
      I think you may be pasting more than you need.

      • #2673631

        Reply To: Problem in Excel

        by dklippert ·

        In reply to Reply To: Problem in Excel

        Ctrl+R is just copying the entry on the left to the right.
        Look Try using Edit Paste Special to Paste as text rather than HTML

      • #2673630

        Reply To: Problem in Excel

        by dklippert ·

        In reply to Reply To: Problem in Excel

        CTRL+D copies the entry above down one cell

    • #3314311

      Reply To: Problem in Excel

      by davidfranks78 ·

      In reply to Problem in Excel

      See if this helps:

      When you copy from the website, don’t directly paste. Use the “Paste Special” option and select “Values”.
      Edit -> Paste Special – > Values

      Good luck

Viewing 3 reply threads