Animals1977
New Member
- Joined
- Feb 15, 2019
- Messages
- 1
Hi folks,
hope you can help me.
I am using Microsof Excel for Office 365 MSO (16.0.11029.20104) 64-bit.
I am trying to create a shared expenses spreadsheet, using the template from this tutorial www.exceltactics.com/how-to-split-bills-and-share-expenses-using-a-free-excel-spreadsheet/ - I managed to do what I wanted though I am encoutering 2 problems.
1. the spreadsheet works well on local file but when i export it to google drive, when I want to select a name using the drop down menu it doesn't work as it should. See below to understand the issue.
This is a screen from the local Excel file. The drop down menu works perfectly, I can select a name and the formula then apply.
This is a screen from the google drive live Excel file. As you can see the drop down menu get stuck on "chargement en cours" which means "loading". So the names never loads. Also as you can see there is that red arrow on each corners of the name selection and when I highlight it the following message appear "Non valide : la valeur d'entrée doit être comprise dans la plage spécifiée" which should mean in english "Invalid: the input value must be within the specified range".
Please how can I make it work on the cloud ?
2. I have copied the worksheet within the workbook in order to track multiple categories. However when I do this the formula for the Settlement is the same on every worksheet (the original one) instead of reflecting what the settlement for that specific worksheet should be. Example: I want one sheet per month.
There is a hidden worksheet where the calculations are done called "Settlement Transations". Unhide it and you can decode the formulas. However this sheet is called on any other monthly sheet I create. The solution I found is to create 1 hidden sheet per month.
Is there another way to fix this so I only have 1 hidden sheet ?
Thanks for your kind help.
Animals1977.
hope you can help me.
I am using Microsof Excel for Office 365 MSO (16.0.11029.20104) 64-bit.
I am trying to create a shared expenses spreadsheet, using the template from this tutorial www.exceltactics.com/how-to-split-bills-and-share-expenses-using-a-free-excel-spreadsheet/ - I managed to do what I wanted though I am encoutering 2 problems.
1. the spreadsheet works well on local file but when i export it to google drive, when I want to select a name using the drop down menu it doesn't work as it should. See below to understand the issue.
This is a screen from the local Excel file. The drop down menu works perfectly, I can select a name and the formula then apply.
This is a screen from the google drive live Excel file. As you can see the drop down menu get stuck on "chargement en cours" which means "loading". So the names never loads. Also as you can see there is that red arrow on each corners of the name selection and when I highlight it the following message appear "Non valide : la valeur d'entrée doit être comprise dans la plage spécifiée" which should mean in english "Invalid: the input value must be within the specified range".
Please how can I make it work on the cloud ?
2. I have copied the worksheet within the workbook in order to track multiple categories. However when I do this the formula for the Settlement is the same on every worksheet (the original one) instead of reflecting what the settlement for that specific worksheet should be. Example: I want one sheet per month.
There is a hidden worksheet where the calculations are done called "Settlement Transations". Unhide it and you can decode the formulas. However this sheet is called on any other monthly sheet I create. The solution I found is to create 1 hidden sheet per month.
Is there another way to fix this so I only have 1 hidden sheet ?
Thanks for your kind help.
Animals1977.
