Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to save values only from linked Excel files?
I have a very large Excel file due to linked data files. Is it possible to
save in a separate Excel file the values only from the linked files [and not the links] to reduce the file size for e-mailing? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to save values only from linked Excel files?
Save the file as a new name
then select the cells edit|copy edit|paste special|Values This will convert all the formulas to values. If that's too much, you may be able (depending on your version): edit|links|break links. If your version of excel doesn't have this option, you could use Bill Manville's addin to find the external links and change them to values: http://www.oaltd.co.uk/MVP/Default.htm jmadam39 wrote: I have a very large Excel file due to linked data files. Is it possible to save in a separate Excel file the values only from the linked files [and not the links] to reduce the file size for e-mailing? -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to save values only from linked Excel files?
Thank you Dave for your quick response. I forgot to mention that all the
linked data is displayed in numerous pivot tables [Edit|Links cannot be selected (Excel 2003)]. The Edit|Paste Special|Values did work but the Pivot Table formatting was lost. Is there a way to freeze the data in the Pivot Tables without the links to the source data? "Dave Peterson" wrote: Save the file as a new name then select the cells edit|copy edit|paste special|Values This will convert all the formulas to values. If that's too much, you may be able (depending on your version): edit|links|break links. If your version of excel doesn't have this option, you could use Bill Manville's addin to find the external links and change them to values: http://www.oaltd.co.uk/MVP/Default.htm jmadam39 wrote: I have a very large Excel file due to linked data files. Is it possible to save in a separate Excel file the values only from the linked files [and not the links] to reduce the file size for e-mailing? -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to save values only from linked Excel files?
The formatting of the PT shouldn't have been lost--but the PT itself was.
I don't know of any way to keep the pivottable, but to lose the links. But maybe someone else does. jmadam39 wrote: Thank you Dave for your quick response. I forgot to mention that all the linked data is displayed in numerous pivot tables [Edit|Links cannot be selected (Excel 2003)]. The Edit|Paste Special|Values did work but the Pivot Table formatting was lost. Is there a way to freeze the data in the Pivot Tables without the links to the source data? "Dave Peterson" wrote: Save the file as a new name then select the cells edit|copy edit|paste special|Values This will convert all the formulas to values. If that's too much, you may be able (depending on your version): edit|links|break links. If your version of excel doesn't have this option, you could use Bill Manville's addin to find the external links and change them to values: http://www.oaltd.co.uk/MVP/Default.htm jmadam39 wrote: I have a very large Excel file due to linked data files. Is it possible to save in a separate Excel file the values only from the linked files [and not the links] to reduce the file size for e-mailing? -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
How to save sheets in new excel files, automatically? | Excel Worksheet Functions | |||
Linked files don't work after upgrade | Excel Discussion (Misc queries) | |||
Excel 2000 worksheets save incorrectly as notepad files. | Excel Discussion (Misc queries) | |||
Excel Files Acting Weird | Excel Discussion (Misc queries) |