I HAVE ERRORNEOUSLY POSTED MY QUERY IN WRONG SECTION. I DONT KNOW HOW TO DELETE THE THREAD THAT'S WHY I AM EDITITING THE THREAD BY THIS MESSAGE. I AM RE POSTING THIS THREAD IN EXCEL HELP SECTION.
I am using Excel 2007. I used to Export Excel Data file from SAP and then save these files on my Computer. Usually I use formulas like VLOOKUP, SUMIFS or SUMIF. All these formulas link with other Excel workbook. Before closing the file I save both the files i.e. Excel workbook exported from SAP and the source file. When I open the file which is exported from the software, in all the row where I used the formula which is linked from other workbook, there appears #Value Error. Then I have to open the source file then all these #VALUE EORROR converted into formulas.
I means whenever I have to see my working, I have to open both the workbook. The file exported from SAP and the source file from which table array of vlook up linked. Due to this problem, I can't send my file through email. In order to email my file, file I have to copy my working and then paste all these working as VALUE. If i dont to this, then my receipiant also find same error (#VALUE ERROR) in all rows.
Due to this error, every time I have to enter formula from beginning. Although I have found temporary solution for this. I use to copy the source sheet in my working file so there should be no #VALUE ERROR. But I dont wont to copy source sheet in my working file every time.
Kindly give me solution.
Reply With Quote
Bookmarks