Export to Cloud

**Animals1977** · 02-02-2019, 06:28 AM

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 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 the Cloud, 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.

excel001.jpg

This is a screen from the Cloud 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".

excel002.jpg

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 ?

excel003.jpg

Thanks for your kind help.

Animals1977.

**6StringJazzer** · 02-02-2019, 10:16 AM

How is the data validation for that cell defined?

Can you attach your file? It would be more helpful than a screen shot. The paper clip icon does not work for attachments. To attach a file, under the text box where you type your reply click the Go Advanced button. On the next screen scroll down and click on Manage Attachments, which will show a pop-up window to Select and Upload a file. Then close the window.

**Animals1977** · 02-02-2019, 06:30 PM

Hi 6StringJazzer;

Thanks for your feedback. You can download my file here excelforum.com/attachment.php?attachmentid=609444&stc=1&d=1549146573

**6StringJazzer** · 02-02-2019, 11:35 PM

I can't reach your file through that URL. Please attach directly to your post as described.

**Animals1977** · 02-03-2019, 06:17 AM

Voilà. Does it work ?

**6StringJazzer** · 02-03-2019, 08:27 AM

Parfaitement. But I'm unable to reproduce the error, so I'm not sure I can help. I have Office 2019 on my desktop and I tried Excel online on a SharePoint site and they both worked. When you say "The Cloud" what do you mean? Is that a Microsoft OneDrive site? I will probably have to step aside and hope for someone who has the same version as you.