LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default I want to save a copy of a wksht. but without any of the formulas

Is there a trick to saving a worksheet keeping all values but erasing the
formulas behind the cells? I have been copying a excel workbook that others
in my company edit and displaying our content on SharePoint. My company owns
a version of SPoint that doesn't support many of Excel's features used in
creations of workbooks, thus leaving me with editing out lots of things (Even
IMAGES!). haha.

But my question is, can i easily take out formulas, vlookups, macros, or
other things and still preserve the cell contents as they are even when the
values rely on other sheets or looking up something in other cells with
formulas?

thanks!
Mike
 
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
1st 2 rows of wksht show up @ top of each page of the wksht Remote Paralegal Excel Discussion (Misc queries) 2 October 6th 08 07:59 PM
Macro to Copy/Paste Data into one wksht, skipp one row before past Shoney Excel Discussion (Misc queries) 1 February 22nd 08 01:28 AM
Can I copy page set ups in Excel 2003 from one wksht to another MHacct Excel Worksheet Functions 1 August 9th 07 05:40 PM
Save As and save current numbers not the actual formulas and links Frank Menard Excel Discussion (Misc queries) 2 November 9th 06 09:18 PM
How do I save a copy of an excel file without the formulas? Saving Excel File without Formula Excel Worksheet Functions 1 February 14th 05 08:55 PM


All times are GMT +1. The time now is 10:01 PM.

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"