error: Not enough memory for VLOOKUP using external file

  • Thread starter Thread starter Trajano Roberto
  • Start date Start date
T

Trajano Roberto

hi all,

we are encountering an error "Not enough memory" when we try to save
Pricing.xlt template file containing the following formula:
=VLOOKUP(B7,[_bpcs_pricing.xls]BPCS!$A1:$E$62050,2,FALSE)

we are using Microsoft Excel 97 SR-2

_bpcs_pricing.xls is an external file containing all our data
Pricing.xlt is a template file containing the following blank columns:
Item # <auto increment starting from 1>
Item code <entered by the user>
Item description <retrieved by VLOOKUP from external file>
List price <retrieved by VLOOKUP from external file>

Our goal is for the user to type an item code in Pricing.xlt, and VLOOKUP to
retrieve the respective item description and list price from
_bpcs_pricing.xls

Upon setting up Pricing.xlt and trying to save the file, the following error
message appears:
a) Not enough memory
b) Unable to save external link values

thanks in advance for any assistance
 
hi Charlie,

thank you very much for your help

regards,

Trajano Roberto
Charles Williams said:
see
http://support.microsoft.com/?kbid=167079

and
http://support.microsoft.com/?kbid=214342

try opening the _bpcs_pricing.xls file first


Charles
______________________
Decision Models
FastExcel 2.1 now available
www.DecisionModels.com

Trajano Roberto said:
hi all,

we are encountering an error "Not enough memory" when we try to save
Pricing.xlt template file containing the following formula:
=VLOOKUP(B7,[_bpcs_pricing.xls]BPCS!$A1:$E$62050,2,FALSE)

we are using Microsoft Excel 97 SR-2

_bpcs_pricing.xls is an external file containing all our data
Pricing.xlt is a template file containing the following blank columns:
Item # <auto increment starting from 1>
Item code <entered by the user>
Item description <retrieved by VLOOKUP from external file>
List price <retrieved by VLOOKUP from external file>

Our goal is for the user to type an item code in Pricing.xlt, and VLOOKUP
to
retrieve the respective item description and list price from
_bpcs_pricing.xls

Upon setting up Pricing.xlt and trying to save the file, the following
error
message appears:
a) Not enough memory
b) Unable to save external link values

thanks in advance for any assistance
Click to expand...
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Would like to retrieve values from an external file using VLOOKUP 3
Ignore calculation if text 4
List Boxes (Help!) 2
Use vlookup within offset? 4
indirect w/ vlookup = #REF error 1
Vlookup referring to External Workbook or Spreadsheet 1
Vlookup issue 2
Windows Photo Viewer can’t display this picture because there might not be enough memory available on your computer. 3

Back
Top