Hi all,
Situation: I have a backend excel file and I have a frontend excel file. The frontend files copies needed data from the backend table once a user logins. My frontend file creates various reports in forms of pivots and pivot charts. To create these the frontend model uses a data model were all the tables are connected via relationships. All the raw data at this point (after the login) is included in the frontend so no connections to outside data sources.
Problem: Everything works as it should, just the initial loading of the data model after the login takes like 15-20 seconds which is not the best user experience. So my idea was to reduce the size of the data model by only loading relevant columns. As it stands some of the tables have columns that are not needed to create the reports (but are necessary for other purposes) and therefor are unnecessary to have in the data model.
However I cannot seem to delete single columns from the data model. The button is greyed out and whenever i try to google this I find a lot on how to load partial data from other sources, however nothing on how to do that if the data is included in the same workbook.
Any help or pointers would be much appreciated.
Best,
Max
Situation: I have a backend excel file and I have a frontend excel file. The frontend files copies needed data from the backend table once a user logins. My frontend file creates various reports in forms of pivots and pivot charts. To create these the frontend model uses a data model were all the tables are connected via relationships. All the raw data at this point (after the login) is included in the frontend so no connections to outside data sources.
Problem: Everything works as it should, just the initial loading of the data model after the login takes like 15-20 seconds which is not the best user experience. So my idea was to reduce the size of the data model by only loading relevant columns. As it stands some of the tables have columns that are not needed to create the reports (but are necessary for other purposes) and therefor are unnecessary to have in the data model.
However I cannot seem to delete single columns from the data model. The button is greyed out and whenever i try to google this I find a lot on how to load partial data from other sources, however nothing on how to do that if the data is included in the same workbook.
Any help or pointers would be much appreciated.
Best,
Max