Hi,
Up until a week ago my company used Excel 2013 but we have now been upgraded to Office 365 with Excel 2016. Yay! A year ago I built an analysis template with accumulated weekly sales data with the power pivot addin, and had to upgrade the model to be able to use the report with the new Office 365. Everything seemed fine but except that a lot of columns with numeric data got formatted as text after the upgrade. I changed all these back to whole number in the power pivot window which made all the measures and calculations work again.
But then I ran into a huge problem: random rows in the data set has gotten faulty numeric values after this. For example, some rows which before had numeric values formatted as 12,345.67 has now got the value 1,234,567.00 or 123,456.70 or any other random base 10 multiplier. This happens very randomly throughout the entire dataset and I can't find a solution to revert it back. Since our sales database only logs 4 weeks of selling for specific measures that I use I cannot pull a new set but have to rely ond the old accumulated data from previous versions of the file.
What I have tried so far:
As the dataset is about 200 000 rows I cannot manage this manually. Has anyone ever run into this problem or have any idea what I could try? I could rebuild the entire file, but that would mean that we lose about a year of accumulated sales data because of the restrictions in the database.
Thank you for any input, and if you need any infromation just let me know!
BR Olof
Up until a week ago my company used Excel 2013 but we have now been upgraded to Office 365 with Excel 2016. Yay! A year ago I built an analysis template with accumulated weekly sales data with the power pivot addin, and had to upgrade the model to be able to use the report with the new Office 365. Everything seemed fine but except that a lot of columns with numeric data got formatted as text after the upgrade. I changed all these back to whole number in the power pivot window which made all the measures and calculations work again.
But then I ran into a huge problem: random rows in the data set has gotten faulty numeric values after this. For example, some rows which before had numeric values formatted as 12,345.67 has now got the value 1,234,567.00 or 123,456.70 or any other random base 10 multiplier. This happens very randomly throughout the entire dataset and I can't find a solution to revert it back. Since our sales database only logs 4 weeks of selling for specific measures that I use I cannot pull a new set but have to rely ond the old accumulated data from previous versions of the file.
What I have tried so far:
- Removing all the data from the new model and insert the entire old data set once more from previous versions that were working as intended before the upgrade
- Tried numerous number formatting on each column in the powerpivot window
- Format all cells in the linked tables as i want them to be
As the dataset is about 200 000 rows I cannot manage this manually. Has anyone ever run into this problem or have any idea what I could try? I could rebuild the entire file, but that would mean that we lose about a year of accumulated sales data because of the restrictions in the database.
Thank you for any input, and if you need any infromation just let me know!
BR Olof
