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

Can you attach the workbook?

Hi,

Thank you for your response. Please find attached the workbooks as requested.

Attached Files

	ADR 17-01-18 - detail.xlsx (74.4 KB, 29 views)
	ADR 17-01-23 - detail.xlsx (53.7 KB, 19 views)

Weird. I can't seem to open the links.

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.

I opened both, just some SUM functions here and there...

__________________
Using O365 v2503 - 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

Are the actual files with this problem .xlsx or are they .xls (ie:saved in pre Office 2007 format) ?