| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
2007 file not being read correctly in 2003
Ok, so below is the equation I have with my cells I am having trouble with:
=INDEX('Front End-MSP'!A1:A22,RANDBETWEEN(1,COUNTA('Front End-MSP'!A1:A22)),RANDBETWEEN(1,1)) I have excel 2007 at home on my PC, at my office we only have 2003 version. The equation above work perfectly at home, but when I attempt to open it at the office it comes up with a "name" error. Does anyone happen to have any ideas for me? Thank you |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
2007 file not being read correctly in 2003
The RANDBETWEEN function is built-in to XL2007 but requires the Analysis
ToolPak add-in to be loaded in order to work in XL2003 and earlier. Click Tools/Add-Ins from XL2003's menu bar, put a check mark next to Analysis ToolPak, and then click OK. Rick "Throme88" wrote in message ... Ok, so below is the equation I have with my cells I am having trouble with: =INDEX('Front End-MSP'!A1:A22,RANDBETWEEN(1,COUNTA('Front End-MSP'!A1:A22)),RANDBETWEEN(1,1)) I have excel 2007 at home on my PC, at my office we only have 2003 version. The equation above work perfectly at home, but when I attempt to open it at the office it comes up with a "name" error. Does anyone happen to have any ideas for me? Thank you |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
2007 file not being read correctly in 2003
Thank you, and sorry, I just thought my wording of the subject would have
been confusing or overlooked. "Rick Rothstein (MVP - VB)" wrote: The RANDBETWEEN function is built-in to XL2007 but requires the Analysis ToolPak add-in to be loaded in order to work in XL2003 and earlier. Click Tools/Add-Ins from XL2003's menu bar, put a check mark next to Analysis ToolPak, and then click OK. Rick "Throme88" wrote in message ... Ok, so below is the equation I have with my cells I am having trouble with: =INDEX('Front End-MSP'!A1:A22,RANDBETWEEN(1,COUNTA('Front End-MSP'!A1:A22)),RANDBETWEEN(1,1)) I have excel 2007 at home on my PC, at my office we only have 2003 version. The equation above work perfectly at home, but when I attempt to open it at the office it comes up with a "name" error. Does anyone happen to have any ideas for me? Thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Share 2007 files on SBS 2003 server - read-only doesn't display us | Excel Discussion (Misc queries) | |||
| Excell 2003 spread sheet not opening correctly in 2007 | Setting up and Configuration of Excel | |||
| If I transfer a 2007 office file to a PC with 2003 can it read it | Excel Discussion (Misc queries) | |||
| 2007 Opening 2003 Files as Read Only | New Users to Excel | |||
| Excel 2003 does not open html file correctly | Excel Discussion (Misc queries) | |||
Linear Mode
