20 September 2009
Tally ODBC helps establish a dynami connectivity of 7.2/9 with excel. When used for creating a trial balance in excel, we can then prepare B/S & P&L in excel as well that will adjust as per changes made in taly. My question is, such a trial balance is arranged in a certain way in excel and is connected via formula to cells in B/S n P&L. If we create a new A/c in tally this arrangement changes nd thus all the figures in B/S n P&L need to be connected again to the T.B. cells nd this disadvantage nulifies ODBC utility to a great extent since greater portion of excel sheets need to be reworked then. Is there a proper solution to this?
20 September 2009
you can prepair Excel Trial by using Tally Trial. Export trial In Excel then once again prepair other trial on next sheet by using Vlookup comod.then go to Balance sheet so every time it will work.