Multiple Sheet Excel Form Report

[Mase18]

Hello and thanks in advance. I just started working with PC-DMIS 2019 R1 and tried to use the Excel Form Report. Watching the short company video I was able to get it to output all my dimensions to a custom Excel sheet that I put in the Templates folder.

I have 3 sheets in this Excel file. The 1st sheet lists all the data. The 2nd sheet contains formulas that populate cells after reading data from the 1st sheet. The 3rd sheet contains a macro that further evaluates the data (pass or fail) from the 2nd sheet.

My problem is the PC-DMIS Excel Form Report only populates the 1st sheet with my data (or at least as far as I can see) because when I open the 2nd Sheet (Evaluation Sheet) or the 3rd Sheet (Non-Conformance Sheet) they both start with rows 1 and 2 then skip all the way down to rows 502, 503, etc...

Is there a way to correct this or open those sheets so that I can see if rows 3 thru 501 populated with anything? Any help is greatly appreciated.

[Mike Ruff]

I use PC-DMIS 2015.1 so I'm not sure if this is the issue or not, but when I output to Excel from PC-DMIS, it imports the data as text, not as numbers. If you try to do any sort of function on a cell with a number in it that is formatted as text, it will not work. I had to use the VALUE() function in Excel to convert from text to a number. Then everything in my sheets worked properly. HINT: Text is left-aligned in the cell, Numbers are right-aligned in the cell. So if the numbers you are trying to work with are left-aligned, try using VALUE() and it should work!

[Mase18]

Thanks.