Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
links
spreadsheet a and linking to b. spreadsheet a's date comes in as 3/16/2014
on spreadsheet b even though it says 3/15/2010 on spreadsheet a. i have same format for date in both |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
links
One of the workbooks is using a base date of 1900 (normal for WinTel users) and
the other is using 1904 as the base date (normal for Mac users--and users who want to see negative dates/times). You could change the base date to match. In xl2003 menus: Tools|Options|calculation tab|Check or uncheck the 1904 date system checkbox. But if you do this, then all the dates in the workbook that you're changing will be off by 1462 days--and you'll have to make sure you fix all those dates. But as long as you're aware of the cause, you can add/subtract that 1462 value to your formula: =[book2.xls]Sheet1!$A$1 - 1462 (or add that value. It'll depend on what workbook is sending the value and what workbook is receiving.) jmm1954 wrote: spreadsheet a and linking to b. spreadsheet a's date comes in as 3/16/2014 on spreadsheet b even though it says 3/15/2010 on spreadsheet a. i have same format for date in both -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Slow opening links between workbooks with links created in 2003 | Excel Discussion (Misc queries) | |||
Update links box gives Continue or Edit Links dialog | Excel Discussion (Misc queries) | |||
Edit Links: Changing links on a protected worksheet | Excel Discussion (Misc queries) | |||
EXCEL - LINKS cannot easily get list of all links & names in book | Excel Worksheet Functions | |||
can't update links...can't find links | Excel Discussion (Misc queries) |