error: Not enough memory for VLOOKUP using external file

  • Thread starter Trajano Roberto
  • 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
 
T

Trajano Roberto

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...
 

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
indirect w/ vlookup = #REF error 1
ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
vlookup (indirect, or sumproduct) using three tabs 3
Not enough memory error 3
Vlookup with multiple corresponding values 3
Not enough memory error 1
VLOOKUP ERROR 3

Top