| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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??? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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??? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF formula? | Excel Worksheet Functions | |||
| Formula works in some cells, doesn't in other | New Users to Excel | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Problem with VBA returning the contents of a long formula. | Excel Discussion (Misc queries) | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Linear Mode
