| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Splitting a file with lookup functions into smaller parts
I have a large file I want to split into several smaller pages. It has the
VLOOKUP function in it that refers to specific pages within the worksheet. What is the fastest way to save one page of the worksheet without losing all the values when I delete the pages that the VLOOKUP function refers to? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Splitting a file with lookup functions into smaller parts
You can select everything, click copy, and then do a Paste Special and select
Values. "Dave McD" wrote: I have a large file I want to split into several smaller pages. It has the VLOOKUP function in it that refers to specific pages within the worksheet. What is the fastest way to save one page of the worksheet without losing all the values when I delete the pages that the VLOOKUP function refers to? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Splitting a file with lookup functions into smaller parts
Highlight the cells with VLOOKUP functions, and do Edit/Copy. Then,
do Edit/Paste Special, and select Values (or Values and Number Formats, if appropriate). Then, you can right-click on the worksheet tab, select Move or Copy, in the dropdown select "New Workbook", and uncheck the "Create a Copy" box if you don't want it to stay in the original large workbook. On Oct 24, 4:16 pm, Dave McD <Dave wrote: I have a large file I want to split into several smaller pages. It has the VLOOKUP function in it that refers to specific pages within the worksheet. What is the fastest way to save one page of the worksheet without losing all the values when I delete the pages that the VLOOKUP function refers to? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Splitting a file with lookup functions into smaller parts
Copy/paste special/values/ok/esc
Gord Dibben MS Excel MVP On Wed, 24 Oct 2007 13:16:01 -0700, Dave McD <Dave wrote: I have a large file I want to split into several smaller pages. It has the VLOOKUP function in it that refers to specific pages within the worksheet. What is the fastest way to save one page of the worksheet without losing all the values when I delete the pages that the VLOOKUP function refers to? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Making a file smaller | Setting up and Configuration of Excel | |||
| Dependant parts list -lookup | Excel Discussion (Misc queries) | |||
| Auto repeate parts of functions | Excel Worksheet Functions | |||
| Calculating Cells - Slower in Smaller File | Excel Discussion (Misc queries) | |||
| is there a way to make an Excel file smaller than 296K? | Excel Discussion (Misc queries) | |||
Linear Mode
