Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default copy of excel file not showing formulal/function in the function b

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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,501
Default copy of excel file not showing formulal/function in the function b

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

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

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default copy of excel file not showing formulal/function in the function b

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
  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default copy of excel file not showing formulal/function in the functi

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 secu-

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

  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default copy of excel file not showing formulal/function in the functi

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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy function with Excel 2003 not performing correctly wtztips Excel Worksheet Functions 2 June 11th 07 05:06 PM
Showing Error when going to pass a function like this Brahmananda Mohanty Excel Worksheet Functions 1 May 6th 07 07:50 AM
Weakness in the Cut / Copy Paste function of Excel 2007 Beta Mr. Low Excel Worksheet Functions 3 October 3rd 06 05:51 PM
In Excel, how can I stop the drag function to copy and not add? DavidClaborn Excel Worksheet Functions 3 July 1st 06 10:50 PM
GetFormula function- Need help showing formulas only- [email protected] Excel Worksheet Functions 2 January 9th 06 03:52 PM


All times are GMT +1. The time now is 01:19 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"