| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using Paste Link
I made a Query in Access 2007 and used to Copy buttons to put a copy on the
clipboard. Then I opened Excel 2007 and tried to use the Paste Link option. But all I get is the Hour Glass. Is there a way to paste this Query as a Link into Excel? Thanks, Tom Roberts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using Paste Link
Hi,
Try it from inside Excel. Choose Data, Get External Data, From Access, locate the file and click Open, pick the table or query you want and click OK, OK. The resulting table will be linked back to Access and refresh it anytime by choosing Table Tools, Design, Refresh. Or you can click the Data, Refresh All command. In 2007 there are also shortcut keys for Refresh and Refresh All - Alt+F5, and Ctrl+Alt+F5. If this helps, please click the Yes button Cheers, Shane Devenshire "Tom Roberts" wrote: I made a Query in Access 2007 and used to Copy buttons to put a copy on the clipboard. Then I opened Excel 2007 and tried to use the Paste Link option. But all I get is the Hour Glass. Is there a way to paste this Query as a Link into Excel? Thanks, Tom Roberts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using Paste Link
Worked like a charm.
Thank you. "Shane Devenshire" wrote: Hi, Try it from inside Excel. Choose Data, Get External Data, From Access, locate the file and click Open, pick the table or query you want and click OK, OK. The resulting table will be linked back to Access and refresh it anytime by choosing Table Tools, Design, Refresh. Or you can click the Data, Refresh All command. In 2007 there are also shortcut keys for Refresh and Refresh All - Alt+F5, and Ctrl+Alt+F5. If this helps, please click the Yes button Cheers, Shane Devenshire "Tom Roberts" wrote: I made a Query in Access 2007 and used to Copy buttons to put a copy on the clipboard. Then I opened Excel 2007 and tried to use the Paste Link option. But all I get is the Hour Glass. Is there a way to paste this Query as a Link into Excel? Thanks, Tom Roberts |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 'paste special', 'paste link' formatting transfer | Excel Discussion (Misc queries) | |||
| PASTE LINK option not available when I select PASTE SPECIAL to link an image in Excel to a Word document. | Links and Linking in Excel | |||
| Formatting not retained using paste all and paste link | Excel Worksheet Functions | |||
| "paste special" "paste link" | Excel Discussion (Misc queries) | |||
| Paste Link enters a 0 into the cell where I paste. How do I elemin | Excel Discussion (Misc queries) | |||
Linear Mode
