![]() |
#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 |
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 |
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 |
All times are GMT +1. The time now is 11:17 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com