#1
|
|||
|
|||
I'm struggling to do a Vlookup in MS office 16
I keep getting the following message:
"There's is a problem with this reference. This file can only have formulas that reference cells within a worksheet size of 256 columns (column IW or lower) or 65536 rows." I have never seen this before when doing a Vlookup and don't know what it means except that it won't let me do the Vlookup. Can anybody help? Thank you |
#2
|
|||
|
|||
Can you attach the workbook?
|
#3
|
|||
|
|||
Hi,
Thank you for your response. Please find attached the workbooks as requested. |
#4
|
|||
|
|||
Weird. I can't seem to open the links.
|
#5
|
|||
|
|||
OK...I got one to open. When are you getting the error? I looked for formulas that might cause it and could not find any.
|
#6
|
||||
|
||||
I opened both, just some SUM functions here and there...
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#7
|
|||
|
|||
Are the actual files with this problem .xlsx or are they .xls (ie:saved in pre Office 2007 format) ?
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Struggling with a layout issue. Need Help, Please! | Moondoggy | Word | 2 | 08-08-2016 07:38 PM |
struggling with simple task | jayhammond | Word VBA | 3 | 03-04-2016 08:58 AM |
Struggling to set A4 Jpg image as Word document background? | acknowledged74 | Word | 2 | 10-18-2014 01:39 PM |
Help using If and Vlookup | heastlund | Excel | 3 | 08-04-2014 01:34 PM |
struggling with Excel formula | riccam87 | Excel | 1 | 05-02-2014 07:21 AM |