Thread: Getting fault substance as making Pivot table in Excel 2007: ‘information source ref.

Hello Friends,

Ihave set up Microsoft Office 2007 on the machine of mine. Good I amappearing to make Pivot table on the machine of mine. Still I amtesting to do it is reminding with an fault substance on the machineof mine. The fault content can be stated as next ‘informationsource reference is not valid’. Let me recognize if you are havinganything peculiar solution to fix the issue of mine. Thanks a lot inadvance.

Thanks,

I require to recognize what type of table as doing Pivot table on theExcel 2010. Also I require to recognize on which information you areneeded apply? If you are trying to do Pivot table on the basis of theExcel range and easy addes the header row with apply unique non blankvalues in each and all cell. In case you are supposed to utulizeexternal information source than you require to give data concerningthe external information source.

The trouble which you have observed can be occurring due to next cause.This peculiar fault content popup on the screen when you have nottake the right range earlier clicking on the Pivot table. You shouldselect the range of the information on the spreadsheet and you haveto insert the ribbon and easy click on the Pivot table. Also if youare having any blank cell take then also you may tackle the aboveobseved trouble as creating Pivot table on Excel.

You can get rid of the over observed trouble by easy utilizing the nextinstruction.You should introduce the Excel on the machine and then gofor Spreadsheet and easy click on the see and go for latest Window.Now you should preserve the spreadsheet by apply latest name. so trythe simlar and let me recognize about the results, I am guessing thatit would be assist to resolve the trouble of yours.

Many times I have watched that such trouble occurs due to corruption ofthe files of this particular program. So I suggest that you shouldtest with reinstalling the software on the machine. Good you shouldremove the software and then make an attempt to set up the similar onthe machine. Make certain that you have restarted the pc later on setup the Microsoft Office on the machine of yours. Let me recognizewhether it is operating or not.


Thanks Friends.