1) Is Power Pivot made for the home user or is it intended for small to medium businesses?
2) The download size is ≈121MB; does that include the SQL Server and do I need SQL Server?
3) Is there any Excel utility that can examine and report on the contents of a cell? I recently had what visually appeared to be valid dates in about a dozen cells (of a table with only 3700 rows) which turned out to be invalid and consequently a date filter used by the pivot table failed. (Through trial and error I was able to determine the dates in error til I finally got the date filter to work by replacing these dates).
Since Excel was not at all helpful in the error message it issued, I'm wondering if there is an Excel Debugging utility?
Thanks,
Dan
2) The download size is ≈121MB; does that include the SQL Server and do I need SQL Server?
3) Is there any Excel utility that can examine and report on the contents of a cell? I recently had what visually appeared to be valid dates in about a dozen cells (of a table with only 3700 rows) which turned out to be invalid and consequently a date filter used by the pivot table failed. (Through trial and error I was able to determine the dates in error til I finally got the date filter to work by replacing these dates).
Since Excel was not at all helpful in the error message it issued, I'm wondering if there is an Excel Debugging utility?
Thanks,
Dan