Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Greetings, and thank you all for looking.
So I broke down and got Office 2007 and I am finding that not only is it really hard to get orientated, but there appears to be some really weird changes. This post is in regards to pasting values from Access into Excel but maintaining the Excel formatting. "Paste Value" was the solution in previous versions...but paste values is not an option when going to Excel. Another thing I noticed is that the paste value in Excel only works while you are using the same instance of Excel. If you have two seperate excels running (open a file in Excel and then use the start/programs... option to open a new instance of excel) the paste value option again won't work. I am also going to post this under Access...but ANY suggestions on quickly transfering selected data from Access into Excel while maintaining the Excel formatting would be GREATLY appreciated. Thanks again for looking. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Migrating Office XP EXCEL files to Office 2007 | Setting up and Configuration of Excel | |||
Why is Paste Formulas option is acting like Paste All option? | Excel Worksheet Functions | |||
In Excel: add a Paste-Special Option to paste IN REVERSE ORDER. | Excel Worksheet Functions | |||
Performance not upto Office 2003 standards in Office 2007 | Excel Discussion (Misc queries) | |||
keep source formatting is not an option in paste option button | Excel Discussion (Misc queries) |