I have a big number of large excel files, each file of them has a number of
worksheets. The values appearing in the cells of each worksheet are mostly
the results of formulae or functions entered into the formula bar. When you
click on one of these cells the formula or function that has been used
appears in the formula bar.
I want to make copies of these files in which, when a cell is clicked on,
the numerical value of that cell, not the formula or function that has been
used, will appear on the formula bar. This is because I need to give these
copied files to somebody and I do not want to him to have knowledge of the
formulae and functions used in the computations .
I tried copying the files using the copy and the "column width, format and
value" alternatives of the special paste method in succession, for each work
sheet seperately, but found it very tedious due to the big numbers of files
and worksheets.
I hope there is a simpler way. I will appreciate your help

Have a look here but note the cautionary remark that this is not very secure:-

http://www.j-walk.com/ss/excel/usertips/tip060.htm

Mike

"oaallam" wrote:

> I have a big number of large excel files, each file of them has a number of
> worksheets. The values appearing in the cells of each worksheet are mostly
> the results of formulae or functions entered into the formula bar. When you
> click on one of these cells the formula or function that has been used
> appears in the formula bar.
> I want to make copies of these files in which, when a cell is clicked on,
> the numerical value of that cell, not the formula or function that has been
> used, will appear on the formula bar. This is because I need to give these
> copied files to somebody and I do not want to him to have knowledge of the
> formulae and functions used in the computations .
> I tried copying the files using the copy and the "column width, format and
> value" alternatives of the special paste method in succession, for each work
> sheet seperately, but found it very tedious due to the big numbers of files
> and worksheets.
> I hope there is a simpler way. I will appreciate your help

If you don't need the formulas to recalculate, maybe you could copy|paste
special|values before you send the file.

If you do need the formulas to recalc, then this won't work.

oaallam wrote:
>
> I have a big number of large excel files, each file of them has a number of
> worksheets. The values appearing in the cells of each worksheet are mostly
> the results of formulae or functions entered into the formula bar. When you
> click on one of these cells the formula or function that has been used
> appears in the formula bar.
> I want to make copies of these files in which, when a cell is clicked on,
> the numerical value of that cell, not the formula or function that has been
> used, will appear on the formula bar. This is because I need to give these
> copied files to somebody and I do not want to him to have knowledge of the
> formulae and functions used in the computations .
> I tried copying the files using the copy and the "column width, format and
> value" alternatives of the special paste method in succession, for each work
> sheet seperately, but found it very tedious due to the big numbers of files
> and worksheets.
> I hope there is a simpler way. I will appreciate your help

--

Dave Peterson

Dear Mike,
Thank you very much for the tip; it is a great help for me.
Best regards
Omer Allam

"Mike H" wrote:

> Have a look here but note the cautionary remark that this is not very secure:-
>
> http://www.j-walk.com/ss/excel/usertips/tip060.htm
>
> Mike
>
> "oaallam" wrote:
>
> > I have a big number of large excel files, each file of them has a number of
> > worksheets. The values appearing in the cells of each worksheet are mostly
> > the results of formulae or functions entered into the formula bar. When you
> > click on one of these cells the formula or function that has been used
> > appears in the formula bar.
> > I want to make copies of these files in which, when a cell is clicked on,
> > the numerical value of that cell, not the formula or function that has been
> > used, will appear on the formula bar. This is because I need to give these
> > copied files to somebody and I do not want to him to have knowledge of the
> > formulae and functions used in the computations .
> > I tried copying the files using the copy and the "column width, format and
> > value" alternatives of the special paste method in succession, for each work
> > sheet seperately, but found it very tedious due to the big numbers of files
> > and worksheets.
> > I hope there is a simpler way. I will appreciate your help

Dear Dave,
I made copies of the files first then I used the copy-value paste on the
copied files themselves. This gave me what I wanted.
Thanks for ur help
Omer Allam

"Dave Peterson" wrote:

> If you don't need the formulas to recalculate, maybe you could copy|paste
> special|values before you send the file.
>
> If you do need the formulas to recalc, then this won't work.
>
> oaallam wrote:
> >
> > I have a big number of large excel files, each file of them has a number of
> > worksheets. The values appearing in the cells of each worksheet are mostly
> > the results of formulae or functions entered into the formula bar. When you
> > click on one of these cells the formula or function that has been used
> > appears in the formula bar.
> > I want to make copies of these files in which, when a cell is clicked on,
> > the numerical value of that cell, not the formula or function that has been
> > used, will appear on the formula bar. This is because I need to give these
> > copied files to somebody and I do not want to him to have knowledge of the
> > formulae and functions used in the computations .
> > I tried copying the files using the copy and the "column width, format and
> > value" alternatives of the special paste method in succession, for each work
> > sheet seperately, but found it very tedious due to the big numbers of files
> > and worksheets.
> > I hope there is a simpler way. I will appreciate your help
>
> --
>
> Dave Peterson
>