View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
RB Smissaert RB Smissaert is offline
external usenet poster
 
Posts: 2,452
Default vlookup to a table on a website

Unless you need web access for other reasons that seems an awkward solution
to me.
If the workbook size really is a problem then I would put the data in a text
file or maybe a database like SQLite.

RBS

"Roger on Excel" wrote in message
...
I have a detailed table used for vlookup in my spreadsheet.

Trouble is, the table is too big and makes the spreadsheet very large.

Is there anyway to use vlookup to access the same data on a webpage i
create
to store the large table? It would reduce the size of my spreadsheet by
50%

Thanks,

Roger