PIvot table data source

%3CLINGO-SUB%20id%3D%22lingo-sub-1271425%22%20slang%3D%22en-US%22%3EPIvot%20table%20data%20source%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1271425%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20'd%20like%20to%20generate%20a%20pivot%20table%20form%20a%20sheet%20in%20which%20some%20cells%20contain%20formulas%20and%20others%20do%20not%20(empty%20cells)%2C%20but%20excel%20does%20not%20discriminate%20considering%20all%20the%20cells%20as%20%22full%22.%3C%2FP%3E%3CP%3Ethe%20data%20in%20the%20source%20sheet%20are%20copy%2Fpaste%20from%20another%20sheet%2C%20but%20seems%20that%20this%20action%20is%20considered%20from%20excel%20as%20pasting%20of%20%22something%22%20whereas%20some%20cells%20are%20empty%20indeed.%3C%2FP%3E%3CP%3EI%20tried%20to%20change%20format%20of%20the%20destination%20cells%20but%20nothing%20change.%20Is%20there%20a%20f(x)%20that%20can%20help%20me%20%3F%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20answer.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1271425%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

Hello,

 

I 'd like to generate a pivot table form a sheet in which some cells contain formulas and others do not (empty cells), but excel does not discriminate considering all the cells as "full".

the data in the source sheet are copy/paste from another sheet, but seems that this action is considered from excel as pasting of "something" whereas some cells are empty indeed.

I tried to change format of the destination cells but nothing change. Is there a f(x) that can help me ?

Thank you for your answer.

0 Replies