Home |
Search |
Today's Posts |
#1
|
|||
|
|||
#N/A vs Blank Cells
Hi there,
I have a excel file full of formulas and a connection to a BD program. I use it on two machines and on one it gives me results of incomplete formulas on a #N/A value, and on the other machine I have a simple blank cell. The only difference is that one machine as WinXP and the other have Win2000. Could this be the cause ??? Regards, Xalam |
#2
|
|||
|
|||
It sounds like you might be using formulas from the Analysis toolpak. Make
sure it's turned on for both PCs. Tools--Addins and choose Analysis toolpak. ******************* ~Anne Troy www.OfficeArticles.com "Xalam" wrote in message ... Hi there, I have a excel file full of formulas and a connection to a BD program. I use it on two machines and on one it gives me results of incomplete formulas on a #N/A value, and on the other machine I have a simple blank cell. The only difference is that one machine as WinXP and the other have Win2000. Could this be the cause ??? Regards, Xalam |
#3
|
|||
|
|||
Thanks for the tip, but donĀ“t work.
The BD program is Hyperion. Regards "Anne Troy" wrote: It sounds like you might be using formulas from the Analysis toolpak. Make sure it's turned on for both PCs. Tools--Addins and choose Analysis toolpak. ******************* ~Anne Troy www.OfficeArticles.com "Xalam" wrote in message ... Hi there, I have a excel file full of formulas and a connection to a BD program. I use it on two machines and on one it gives me results of incomplete formulas on a #N/A value, and on the other machine I have a simple blank cell. The only difference is that one machine as WinXP and the other have Win2000. Could this be the cause ??? Regards, Xalam |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Skip blank cells in diagrams | Charts and Charting in Excel | |||
Copy down - special to fill only the blank cells | Excel Discussion (Misc queries) | |||
What function can make cells shift up when they are blank? | Excel Worksheet Functions | |||
how do you ignore blank cells | Excel Discussion (Misc queries) | |||
Non Blank - Blank Cells???? | Excel Discussion (Misc queries) |