ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Help with formula (https://www.excelbanter.com/excel-discussion-misc-queries/57801-help-formula.html)

Playa

Help with formula
 
I have an excel spread sheet with formulas that work correctly, when I email
them to another person and they open the attachment all looks ok. When they
save the excel file to their PC and open it the formula cells now all have
#Name in them. Anyone know what is causing this???

Gary''s Student

Help with formula
 
The error message gives us a clue: Excel can't find something - things to
check:


1. Make sure the receivers all are using the same add-ins as the sender
2. Make sure that personal.xls is the same for the receivers as the sender
3. Make sure all defined names are the same
--
Gary's Student


"Playa" wrote:

I have an excel spread sheet with formulas that work correctly, when I email
them to another person and they open the attachment all looks ok. When they
save the excel file to their PC and open it the formula cells now all have
#Name in them. Anyone know what is causing this???



All times are GMT +1. The time now is 09:50 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com