| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
VLOOKUP blows up file size
Hi there, I created an excel file "A" with an VLOOKUP to another excel file "B". VLOOKUP seems to cache the results in the excel file "A" with the result of additional 1,7 meg file size in file "A".  I copied only the VLOOKUP formular to a new sheet "C" (still connecting to sheet "B", saved it and opened it with an plain text editor. In the file are lots of data that is not visible in cell to display.  Any idea how to tell excel not to cache unsed data ??? Greets ... -- BlueTill ------------------------------------------------------------------------ BlueTill's Profile: http://www.excelforum.com/member.php...o&userid=25224 View this thread: http://www.excelforum.com/showthread...hreadid=387128 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| File size too big after converting Lotus 1-2-3 to Excel | Excel Discussion (Misc queries) | |||
| File Size | Excel Discussion (Misc queries) | |||
| Large Excel file size caused by a bug ? I really tried everything | Excel Discussion (Misc queries) | |||
| Deleted all images but file size still too big!! | Excel Discussion (Misc queries) | |||
| Importing .txt data files increases .xls file size | Excel Discussion (Misc queries) | |||
Linear Mode
