Search:

Tag: #ref

Search: Replies Views Search took 0.00 seconds; generated 42 minute(s) ago.

  1. [SOLVED] Conditional Formatting #REF errors when removing cell

    Started by Yurang‎, 05-12-2020 06:23 AM
    #ref, color coding., conditional formatting
    • 376
    Last Post: 05-12-2020 09:09 AM
    by Yurang  Go to last post

    Forum:
    Excel General

  2. Replace sheet in workbook with new sheet without #REF formula errors

    Started by ExcelNewbie2020‎, 02-12-2020 10:17 PM
    #ref, formula, formula error, worksheet change
    • 2,298
    Last Post: 02-12-2020 11:23 PM
    by hrlngrv  Go to last post

    Forum:
    Excel Formulas & Functions

  3. Make the vlookup function dynamic for different computers

    Started by ted1234‎, 06-28-2017 03:50 PM
    #ref, dynamic, vlookup
    • 4,079
    Last Post: 07-17-2017 03:09 PM
    by ted1234  Go to last post

    Forum:
    Excel Formulas & Functions

  4. MONTH function returning #REF error

    Started by xtinct2‎, 04-28-2016 04:59 PM
    #ref, error, month, ref
    • 6,061
    Last Post: 04-28-2016 06:00 PM
    by Tony Valko  Go to last post

    Forum:
    Excel General

  5. Data links to sheets yet to be created

    Started by onemarsh‎, 06-10-2015 07:15 AM
    #ref, =value, data link, update sheet
    • 454
    Last Post: 06-10-2015 08:37 AM
    by Evolta  Go to last post

    Forum:
    Excel Formulas & Functions

  6. Structured reference to external data table gives '#REF' when source file is closed

    Started by chrisf78‎, 05-15-2015 03:16 PM
    #ref, external data, structured references
    • 1,126
    Last Post: 05-15-2015 04:31 PM
    by newdoverman  Go to last post

    Forum:
    Excel General

  7. vlookup #ref Error

    Started by gmeadevt‎, 01-23-2015 02:53 PM
    #ref, vlookup
    • 871
    Last Post: 01-23-2015 03:20 PM
    by gmeadevt  Go to last post

    Forum:
    Excel Formulas & Functions

  8. #ref!#ref error for named cells or ranges

    Started by StuCram‎, 01-08-2015 06:56 PM
    #ref, invalid named cell, named cell, naming error
    • 790
    Last Post: 01-08-2015 07:32 PM
    by StuCram  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  9. Sumproduct formula returns #ref when linked data file is closed.

    Started by shandrak‎, 06-23-2014 07:18 PM
    #ref, closed workbook, sumproduct
    • 6,525
    Last Post: 06-23-2014 08:54 PM
    by Tony Valko  Go to last post

    Forum:
    Excel Formulas & Functions

  10. Sum of values in date range returned via GETPIVOTDATA causes #REF errors

    Started by 01111000‎, 06-05-2014 06:25 PM
    #ref, getpivotdata, sum 1 Attachment(s)
    • 4,912
    Last Post: 06-11-2014 03:32 PM
    by 01111000  Go to last post

    Forum:
    Excel General

  11. #REF after row deletion

    Started by ScottyHez‎, 04-17-2014 04:37 AM
    #ref, deletion, row, row deletion
    • 743
    Last Post: 04-17-2014 05:05 AM
    by sktneer  Go to last post

    Forum:
    Excel Formulas & Functions

  12. IF and ADD formula

    Started by NeilB1701‎, 01-14-2014 07:21 AM
    #ref, formula
    • 934
    Last Post: 01-14-2014 08:26 AM
    by martindwilson  Go to last post

    Forum:
    Excel Formulas & Functions

  13. [SOLVED] =isblank returns cell as appearing blank, but not with a blank value resulting in #REF

    Started by bjg108‎, 12-18-2013 06:57 PM
    #ref, indirect
    • 1,099
    Last Post: 12-19-2013 09:49 AM
    by bjg108  Go to last post

    Forum:
    Excel Formulas & Functions

  14. [SOLVED] #REF error when deleting values from a row of concatenated cells.

    Started by mayeuxj‎, 11-13-2013 01:35 PM
    #ref, concatenate, ref error, vba 1 Attachment(s)
    • 1,315
    Last Post: 11-14-2013 03:22 PM
    by mayeuxj  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  15. Unstable Link between Workbooks

    Started by Dritir‎, 05-13-2013 02:40 PM
    #ref, links, multiple, sync, workbooks
    • 1,006
    Last Post: 05-13-2013 02:50 PM
    by Dritir  Go to last post

    Forum:
    Excel General

  16. Eliminate need for duplicating source worksheets for hundreds of workbooks

    Started by snapfade‎, 01-18-2013 08:48 PM
    #ref, duplicated worksheets
    • 624
    Last Post: 01-21-2013 06:41 PM
    by snapfade  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  17. How can I cut and paste a values without getting #Ref (sum, running total)

    Started by roseuz‎, 12-01-2012 12:09 AM
    #ref, checking account, circular reference, cut and paste, invalid reference
    • 1,603
    Last Post: 12-01-2012 01:30 AM
    by Moo the Dog  Go to last post

    Forum:
    Excel General

  18. Indirect.ext keep getting #REF no matter what!

    Started by natasha89‎, 10-07-2012 12:16 AM
    #ref, indirect.ext
    • 1,276
    Last Post: 10-07-2012 01:30 AM
    by FDibbins  Go to last post

    Forum:
    Excel Formulas & Functions

  19. GETPIVOTDATA - giving me a major headache

    Started by custom63willys‎, 09-18-2012 06:07 PM
    #ref, getpivotdata 2 Attachment(s)
    • 4,652
    Last Post: 09-20-2012 05:44 PM
    by custom63willys  Go to last post

    Forum:
    Excel Charting & Pivots

  20. Custom XIRR function for each client

    Started by invman‎, 07-23-2012 05:09 PM
    #ref, xirr
    • 868
    Last Post: 07-23-2012 07:14 PM
    by invman  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  21. Delete cell contents without breaking formulas

    Started by rmf17‎, 02-28-2012 08:39 PM
    #ref, delete data, error
    • 4,400
    Last Post: 03-01-2012 02:30 AM
    by rmf17  Go to last post

    Forum:
    Excel Programming / VBA / Macros

  22. #REF errors on formula laden sheet when data on the referenced sheet moves...??

    Started by lincolnp‎, 03-01-2011 01:44 PM
    #ref
    • 1,310
    Last Post: 03-01-2011 03:31 PM
    by 6StringJazzer  Go to last post

    Forum:
    Excel General

  23. #ref vlookup error

    Started by umpoojari‎, 02-21-2011 07:46 AM
    #ref, multiple files, vlookup, vlookup excel 10, vlookup reference
    • 6,271
    Last Post: 02-14-2012 08:30 PM
    by 6StringJazzer  Go to last post

    Forum:
    Excel Formulas & Functions

  24. CUMIPMT function

    Started by Windsurfer‎, 05-15-2010 12:00 AM
    #ref, cumipmt 3 Attachment(s)
    • 3,081
    Last Post: 05-16-2010 12:48 AM
    by pike  Go to last post

    Forum:
    Excel Formulas & Functions

Results 1 to 24 of 24

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1