Home 
Search 
Today's Posts 
#1
Posted to microsoft.public.excel.misc




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
Posted to microsoft.public.excel.misc




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.jwalk.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
Posted to microsoft.public.excel.misc




copy of excel file not showing formulal/function in the function b
If you don't need the formulas to recalculate, maybe you could copypaste
specialvalues 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
Posted to microsoft.public.excel.misc




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.jwalk.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
Posted to microsoft.public.excel.misc




copy of excel file not showing formulal/function in the functi
Dear Dave,
I made copies of the files first then I used the copyvalue 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 copypaste specialvalues 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 
Display Modes  


Similar Threads  
Thread  Forum  
Copy function with Excel 2003 not performing correctly  Excel Worksheet Functions  
Showing Error when going to pass a function like this  Excel Worksheet Functions  
Weakness in the Cut / Copy Paste function of Excel 2007 Beta  Excel Worksheet Functions  
In Excel, how can I stop the drag function to copy and not add?  Excel Worksheet Functions  
GetFormula function Need help showing formulas only  Excel Worksheet Functions 