| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 11 and Excel 12 addins
Hi,
I was updating excel file (xls) and then saving as addin file (xla) and using it all excel files. Now I am updating the same file (xls) and saving as (xlam) but my formulas in this addins file is not working and value wrong is giving. Problem is what, thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 11 and Excel 12 addins
Bit more info required.
-- --- HTH Bob (change the xxxx to gmail if mailing direct) "bezl" wrote in message ... Hi, I was updating excel file (xls) and then saving as addin file (xla) and using it all excel files. Now I am updating the same file (xls) and saving as (xlam) but my formulas in this addins file is not working and value wrong is giving. Problem is what, thanks. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 11 and Excel 12 addins
Ok.
I added new function in vba module. Master page (xls) has functions and some database which is updated occasionally. I am saving this file as excel 2007 addins (xlam) but functions isn't working. But I am saving this file as excel 2003 addins (xla) then functions is working. but in Excel 2007 files (xlsx) my functions named (vi06(number)) (functions has "0" in it) isn't working because When I wrote functions as "=vi06(5000)" and clicked enter key, written funciton is changing to "vi6(5000)" and give #Ref! error. IN Excel 2003 files there is no problem. Thanks advance for your help. "Bob Phillips" wrote: Bit more info required. -- --- HTH Bob (change the xxxx to gmail if mailing direct) "bezl" wrote in message ... Hi, I was updating excel file (xls) and then saving as addin file (xla) and using it all excel files. Now I am updating the same file (xls) and saving as (xlam) but my formulas in this addins file is not working and value wrong is giving. Problem is what, thanks. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 11 and Excel 12 addins
Ok.
I added new function in vba module. Master page (xls) has functions and some database which is updated occasionally. I am saving this file as excel 2007 addins (xlam) but functions isn't working. But I am saving this file as excel 2003 addins (xla) then functions is working. but in Excel 2007 files (xlsx) my functions named (vi06(number)) (functions has "0" in it) isn't working because When I wrote functions as "=vi06(5000)" and clicked enter key, written funciton is changing to "vi6(5000)" and give #Ref! error. IN Excel 2003 files there is no problem. Thanks advance for your help. "Bob Phillips" wrote: Bit more info required. -- --- HTH Bob (change the xxxx to gmail if mailing direct) "bezl" wrote in message ... Hi, I was updating excel file (xls) and then saving as addin file (xla) and using it all excel files. Now I am updating the same file (xls) and saving as (xlam) but my formulas in this addins file is not working and value wrong is giving. Problem is what, thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| unhide menu bar in excel - just disappeared | Setting up and Configuration of Excel | |||
| excel viewer | Setting up and Configuration of Excel | |||
| Excel file with hyperlinks takes a long time to open over the network | Links and Linking in Excel | |||
| Excel Open Dialog Improper Sort | Excel Discussion (Misc queries) | |||
| how to load addins in Excel | Excel Discussion (Misc queries) | |||
Linear Mode
