Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
2003 V's 2007
Dear All,
To update external link values between to workbooks in 2003 you did this Edit | Links | Update Values. What do you do in 2007? -- Regards Warren Excel Novice Addiewell, Scotland. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
2003 V's 2007
Hi Warren,
You need the Data tab and the Connections section. You will find the Edit Links option there. -- Hope this helps Judith "Warren Easton" wrote: Dear All, To update external link values between to workbooks in 2003 you did this Edit | Links | Update Values. What do you do in 2007? -- Regards Warren Excel Novice Addiewell, Scotland. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
2003 V's 2007
Hi Judith,
Is there anyway I can open two workbooks and have them update automatically when both are open. The workbooks I have don't seem to do this? -- Regards Warren Excel Novice Addiewell, Scotland. "JudithJubilee" wrote: Hi Warren, You need the Data tab and the Connections section. You will find the Edit Links option there. -- Hope this helps Judith "Warren Easton" wrote: Dear All, To update external link values between to workbooks in 2003 you did this Edit | Links | Update Values. What do you do in 2007? -- Regards Warren Excel Novice Addiewell, Scotland. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
2003 V's 2007
Hi Warren,
If you have mulitpl workbooks open then they should automatically update. Are there any external links to other workbooks in either of your two files? If so you will need to open the other ones as well to have them update imediately on screen. -- Hope this helps Judith "Warren Easton" wrote: Hi Judith, Is there anyway I can open two workbooks and have them update automatically when both are open. The workbooks I have don't seem to do this? -- Regards Warren Excel Novice Addiewell, Scotland. "JudithJubilee" wrote: Hi Warren, You need the Data tab and the Connections section. You will find the Edit Links option there. -- Hope this helps Judith "Warren Easton" wrote: Dear All, To update external link values between to workbooks in 2003 you did this Edit | Links | Update Values. What do you do in 2007? -- Regards Warren Excel Novice Addiewell, Scotland. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2007 & 2003 - Default open with 2003 | Excel Discussion (Misc queries) | |||
Excel 2007 Macro Help (Excel 2003 not working in 2007) | Excel Discussion (Misc queries) | |||
Different in 2007 vs 2003 | Charts and Charting in Excel | |||
when 2007 is installed side-by-side with 2003, open xls with 2003 | Setting up and Configuration of Excel | |||
2003 and 2007 | Excel Discussion (Misc queries) |