Deleting Formulas... After using =VLOOKUP

  • Thread starter Thread starter Fury
  • Start date Start date
F

Fury

Hi,

I'm trying to delete the formulas in an entire speadsheet all at once.
The cells are linked to another file, and I just need some of th
information from cells in the other file, and now when I open the ne
one, It requires an update from the second.... This is what I did.

2 separate reports... Report A (the one I need) containing certai
columns of information needed, and is constantly input into by man
users.. roughly 500 employee's worth of data.. and Report B ..
exported from our database.... with a total number of about 300
employees... containing information that is and is not in report A .
and is needed to be placed into the necessary columns of Report A tha
associate to that individual employee's row..

What i did was made an extra column.. and Concatenated the Last, Firs
name, and department of every employee in both reports... then...
entered into the first cell in the empty column of Report A...using th
VLOOKUP function.. looking like this

=VLOOKUP(A3,'[Report B]Report B'!$1:$65536,16,FALSE)


Cell A3 is the empty cell next in the employee row... and 16 is th
column number in Report B...

I then copied this formula into the whole column.. and everythin
pulled fine... but. now when anyone goes to open Report A on ou
network... it asks to update the info from report B.. and it has to b
located and mapped every time... I set report B to be Shared..and eve
put it in the same folder as Report A .. but. no change..

I'm new to using these functions.. I think I'm heading in the righ
direction with this.. but.. now when I go to copy the column fro
Report A that had the Info from Report B.. it only pulls the #ref
error.. and it does the same thing when i try to delete the formula bu
keep the result for each individual cells..

I need to keep the information of Report B in Report A.. but not hav
it linked..

Any thoughts
 
Hi
try the following:
- copy your entire range
- goto 'Edit - Paste Special' and choose 'Values'

this should remove the formulas
 
Thanks So Much!!

It totally worked...

Now.. another small question. Every now and then I have to go to th
Tools, Options, menu...under the "View" tab.. I check the box to plac
the active workbooks in your taskbar... I check the box.. but it keep
going back every now and then to the normal way.. where they jus
minimize in the excel window...

Is there a way to make the "view in taskbar" setting the default on
for all opened spreadsheets
 
Back
Top