Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Pasting from excel
Hi
I have summary sheets set-out like the one below in excel, one tab per area we monitor, about 10 areas Costcentre Budget Spend Proj A1 1000 100 1200 A2 2000 200 2400 Sub total 3000 300 3600 A3 1000 100 1200 A4 3000 300 3600 A5 1000 100 1200 Sub total 5000 500 6000 TOTAL 8000 800 9600 Every month i create a report where i use Paste SpecialBitmap and paste them in, which is OK. But if i make a chnage to the spreadsheet i have to repaste the sheet. I've tried linking but the problem with that is when i archive the report and then open it a month later it picks up current information. Is there anyway around? I've heard people mention using mail merge and MS access but not sure what thats about. All help is appreciated. -- _______________________ Naz, London PS posted on Excel group in case anyone there has any ideas. |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Pasting from excel
I'd try going with the Linking, but when it comes time to do the archived
copy go to EditLinks, select all the links & click the Break Link button. In there you can also set the link to be updated Manual rather than Automatic. Alternatively, you could use the ToolsOptionsGeneral & remove the check for Update Automatic Links on Open, but that's a bit risky IMO. -- HTH |:) Bob Jones [MVP] Office:Mac "Naz" wrote in message ... Hi I have summary sheets set-out like the one below in excel, one tab per area we monitor, about 10 areas Costcentre Budget Spend Proj A1 1000 100 1200 A2 2000 200 2400 Sub total 3000 300 3600 A3 1000 100 1200 A4 3000 300 3600 A5 1000 100 1200 Sub total 5000 500 6000 TOTAL 8000 800 9600 Every month i create a report where i use Paste SpecialBitmap and paste them in, which is OK. But if i make a chnage to the spreadsheet i have to repaste the sheet. I've tried linking but the problem with that is when i archive the report and then open it a month later it picks up current information. Is there anyway around? I've heard people mention using mail merge and MS access but not sure what thats about. All help is appreciated. -- _______________________ Naz, London PS posted on Excel group in case anyone there has any ideas. |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Pasting from excel
P.S.
I neglected to mention that the file asks whether or not to update the link when you open it if the updating is set to Automatic, but not if set to Manual. Most importantly the updating *is* an undoable action, so even if the archive updates you aren't "stuck" with the wrong info You can also close the file without saving changes to preserve the content prior to the update. Another thought as well - Output the archive as a PDF. -- Regards |:) Bob Jones [MVP] Office:Mac "CyberTaz" typegeneraltaz1ATcomcastdotnet wrote in message ... I'd try going with the Linking, but when it comes time to do the archived copy go to EditLinks, select all the links & click the Break Link button. In there you can also set the link to be updated Manual rather than Automatic. Alternatively, you could use the ToolsOptionsGeneral & remove the check for Update Automatic Links on Open, but that's a bit risky IMO. -- HTH |:) Bob Jones [MVP] Office:Mac "Naz" wrote in message ... Hi I have summary sheets set-out like the one below in excel, one tab per area we monitor, about 10 areas Costcentre Budget Spend Proj A1 1000 100 1200 A2 2000 200 2400 Sub total 3000 300 3600 A3 1000 100 1200 A4 3000 300 3600 A5 1000 100 1200 Sub total 5000 500 6000 TOTAL 8000 800 9600 Every month i create a report where i use Paste SpecialBitmap and paste them in, which is OK. But if i make a chnage to the spreadsheet i have to repaste the sheet. I've tried linking but the problem with that is when i archive the report and then open it a month later it picks up current information. Is there anyway around? I've heard people mention using mail merge and MS access but not sure what thats about. All help is appreciated. -- _______________________ Naz, London PS posted on Excel group in case anyone there has any ideas. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pasting an Excel sheet in Word | Microsoft Word Help | |||
Pasting XE fields into Excel | Microsoft Word Help | |||
Pasting from Excel | Microsoft Word Help | |||
Pasting from Excel to Word | Microsoft Word Help | |||
pasting from Excel | Microsoft Word Help |