Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel on multiple computers
i have Register.xls on three computers "Front Left, Front Right, and Back"
i also have Data.xls and Tables.xls that are located on the "Back" computer. all three registers have equations that read off Data.xls and Tables.xls example: =count([data.xls]register!a1:a10000)+count([Tables.xls]new!a1:a1000) the problem is i copy and pasted the version of Register.xls from the back computer that is on the same computer as Data.xls and tables.xls to the computers that read off Data.xls and Tables.xls from the back computer. so now all the equations on the front computers read =count('\\BACKRIGHTCOMP\Choice\[Data.xls]Register'!a1:a1000)+count('\\BACKRIGHTCOMP\Choice\[Tables.xls]new'!a1:a1000) and with the equations like this, they dont update automatically thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hyperlink files on multiple computers | Excel Discussion (Misc queries) | |||
Excel header different on multiple computers. | Excel Discussion (Misc queries) | |||
Need to transfer sheet + pictures to multiple computers | Links and Linking in Excel | |||
How can I move multiple linked workbooks between computers | Excel Discussion (Misc queries) | |||
Editing from Multiple computers? | Excel Discussion (Misc queries) |