Excel 2010 for PC doesnt work on Excel Mac 2011.

[bojan0810]

Hi all.

I dont know if someone is using Excel Mac 2011 or not. I have huge problem with someone who has Mac.

I made spreadsheat in Excel 2010 on Pc. Sent to client who has Excel Mac 2011. He gets all formula values to 0 (showing as errors)... When he clicks to see error he gets Formula Refers to Empty Cells.

As you can see on this sheet
https://dl.dropboxusercontent.com/u/57916703/help.xlsx

Formulas are working. I know they are really really really big lol. But they works. So formulas are on "Transcript Business Dashboard" sheet and they are working for "Transcript Business" sheet. Second sheet isnt important here as it is empty so far.

Anyway problem on mac looks like this
http://postimg.org/image/thcnc1h7n/

What seems to be problem here? I spent alot of hours to make formulas for this sheet and I am really confused now that they arent working. Even it works great on my pc

Thanks

 

[Claus Busch]

Hi Bojan,

Am Sun, 11 May 2014 14:38:49 -0700 (PDT) schrieb (e-mail address removed):

I made spreadsheat in Excel 2010 on Pc. Sent to client who has Excel Mac 2011. He gets all formula values to 0 (showing as errors)... When he clicks to see error he gets Formula Refers to Empty Cells.

it does not working for me too.
I changed the formulas in D1 and D2 and now it is working for me. Please
have a test on Mac.
Have a look:
https://onedrive.live.com/?cid=9378...#cid=9378AAB6121822A3&id=9378AAB6121822A3!326
for your workbook "help"


Regards
Claus B.

 

[Claus Busch]

Hi Bojan,

Am Mon, 12 May 2014 07:46:11 +0200 schrieb Claus Busch:

https://onedrive.live.com/?cid=9378...#cid=9378AAB6121822A3&id=9378AAB6121822A3!326
for your workbook "help"

you can also change all formulas similiar to the formulas in C5, D5 and
E5


Regards
Claus B.

 

[Claus Busch]

Hi Bojan,

Am Sun, 11 May 2014 14:38:49 -0700 (PDT) schrieb (e-mail address removed):

I dont know if someone is using Excel Mac 2011 or not. I have huge problem with someone who has Mac.

to make it work in all language settings I changed the formulas. But
only for the first 3 columns. Change the rest similar.


Regards
Claus B.

 

[bojan0810]

I just love to make complicated formulas when there is so much better lol.

Anyway. Thanks for this.

I asked him to save it on his side yesterday. And send to me. I opened it and I saw all 0 there. But when I clicked enabled editing, everything worked again.

I will let you know when I test it with him.

Thanks. You are great help

 

[Claus Busch]

Hi Bojan,

Am Mon, 12 May 2014 00:22:28 -0700 (PDT) schrieb (e-mail address removed):

I asked him to save it on his side yesterday. And send to me. I opened it and I saw all 0 there. But when I clicked enabled editing, everything worked again.

I had results when I opend the workbook. As soon as I changed B2 I get
only zeros. Your formula in D1 with the dates in quotes makes the dates
to text so they will not match the dates in the other sheet.

=IF(B2="January","1/1/2014", IF(....
It will work if you change it to:
=IF(B2="January",Date(2014,1,1), IF(....

D2 you can change to EOMonth(D1,0)
And row 5 and below you don't have to check for the month because D1 and
D2 change with the month.



Regards
Claus B.

 

[bojan0810]

Dana ponedjeljak, 12. svibnja 2014. 10:05:45 UTC+2, korisnik Claus Busch napisao je:

Hi Bojan,



Am Mon, 12 May 2014 00:22:28 -0700 (PDT) schrieb (e-mail address removed):






I had results when I opend the workbook. As soon as I changed B2 I get

only zeros. Your formula in D1 with the dates in quotes makes the dates

to text so they will not match the dates in the other sheet.



=IF(B2="January","1/1/2014", IF(....

It will work if you change it to:

=IF(B2="January",Date(2014,1,1), IF(....



D2 you can change to EOMonth(D1,0)

And row 5 and below you don't have to check for the month because D1 and

D2 change with the month.







Regards

Claus B.

--

Vista Ultimate / Windows7

Office 2007 Ultimate / 2010 Professional

So that what was causing a problem. I didnt noticed actually that. It was working alright so I didnt looked at that problem at all.

Thanks. I am waiting for reply from that guy with Mac. I totally got confused yesterday when he showed me 0 values. And on my side everything worked.

I hope now with your formula everything will work on Mac. It supposed to be alright all now...

Truly I must say, not because of this, because of all before that I dont like Mac lol.

I had problems before from pc to Mac. Even excel files should be "same" they arent.

Anyway, thanks for this, I will let you know about Mac as soon as he answer.

 

[bojan0810]

Also one more question. Can B2 data validation list be for 2015 too.

For example January, February,..., December, January 2015, February 2015...

Just wondering

 

[Claus Busch]

Hi Bojan,

Am Mon, 12 May 2014 09:38:34 -0700 (PDT) schrieb (e-mail address removed):

Also one more question. Can B2 data validation list be for 2015 too.

unhide sheet ("Help") and change the values in column A and the
reference of the name.

Regards
Claus B.

 

[bojan0810]

Dana ponedjeljak, 12. svibnja 2014. 19:34:20 UTC+2, korisnik Claus Busch napisao je:

Hi Bojan,



Am Mon, 12 May 2014 09:38:34 -0700 (PDT) schrieb (e-mail address removed):






unhide sheet ("Help") and change the values in column A and the

reference of the name.



Regards

Claus B.

--

Vista Ultimate / Windows7

Office 2007 Ultimate / 2010 Professional

Thanks... I forgot to look if something is hidden.

Btw. It worked on Mac.

Thank you so much for helping

 

[Claus Busch]

Hi Bojan,

Am Mon, 12 May 2014 11:13:21 -0700 (PDT) schrieb (e-mail address removed):

Btw. It worked on Mac.

in sheet("Help") you have to write always the first of month and then
format custom MMMM YYYY.
You can also look again in OneDrive. I improved the file.


Regards
Claus B.

 

[bojan0810]

Dana ponedjeljak, 12. svibnja 2014. 21:12:26 UTC+2, korisnik Claus Busch napisao je:

Hi Bojan,



Am Mon, 12 May 2014 11:13:21 -0700 (PDT) schrieb (e-mail address removed):






in sheet("Help") you have to write always the first of month and then

format custom MMMM YYYY.

You can also look again in OneDrive. I improved the file.





Regards

Claus B.

--

Vista Ultimate / Windows7

Office 2007 Ultimate / 2010 Professional

I did that thanks.

Now it is January 14 February 14 etc.

Thanks tho