Referenced cells from other Excel files and need to permanently setcells

[A. Shetti]

Sorry if the subject is confusing, but let me try to explain it better. I am currently using Excel 2007 to create a master file which pulls information from the second worksheet as well as from several other files. The problem is that I want to save a single master file with a single worksheet that doesn't need the other information. I know that if the other files are moved, the master file will still work, only with the "would you like to update?" popup at startup. However, if I try to delete the second worksheet, some of the information in the master file goes missing.

I guess what I'm trying to ask is if there is a way to get the actual value of the cell to show up in the formula bar rather than the '=vlookup()'.

Hopefully this is understandable enough and thanks in advance for the help.

EggHeadCafe - Software Developer Portal of Choice
IIS - Create App Pools, Virtual Directories and Web Sites C# .NET
http://www.eggheadcafe.com/tutorial...476-ff05b085d86e/iis--create-app-pools-v.aspx

 

[Pete_UK]

Select all the cells with formulae in them (eg by clicking on the
column identifiers), and click <copy>, then right-click and click on
Paste Special | Values (check) | OK then <Esc>

All your formulae will now be changed to values, so you can delete the
second worksheet and use Save As to save the file with a new name.

Hope this helps.

Pete