Yes, this is the same spreadsheet that has been applied in my Vista laptop and under my desktop with Windows 8.1 and the Vista laptop has no issues with the resulting calculations.
The Vista laptop spits values such as "41.30" "2.870" etc and these values are simply not there in the desktop.
I appreciate all your help
MACRO will not work in my new windows 8.1 and Office 2013
-
- NewLounger
- Posts: 24
- Joined: 04 Dec 2015, 17:06
-
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Re: MACRO will not work in my new windows 8.1 and Office 201
It would help if you can provide screenshots of the actual formulas producing those #VALUE! errors, as well screenshots of the precedent cells that feed into the formulas. It will assist in determining if the cause of the issue is data entry.
Regards,
Rudi
If your absence does not affect them, your presence didn't matter.
Rudi
If your absence does not affect them, your presence didn't matter.
-
- NewLounger
- Posts: 24
- Joined: 04 Dec 2015, 17:06
Re: MACRO will not work in my new windows 8.1 and Office 201
Since this spreadsheet was created for me, how would you suggest that I find the area where the formulas and precedent cells are stored? Again, sorry to sound dense...
-
- NewLounger
- Posts: 24
- Joined: 04 Dec 2015, 17:06
Re: MACRO will not work in my new windows 8.1 and Office 201
Since this spreadsheet was created for me, how would you suggest that I find the area where the formulas and precedent cells are stored? Again, sorry to sound dense...
-
- Administrator
- Posts: 78665
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: MACRO will not work in my new windows 8.1 and Office 201
Would it be possible to attach a copy of the workbook that does not contain sensitive information to a reply?
Best wishes,
Hans
Hans
-
- NewLounger
- Posts: 24
- Joined: 04 Dec 2015, 17:06
Re: MACRO will not work in my new windows 8.1 and Office 201
I will have to ask the developer of the spreadsheet because it is password protected.
-
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Re: MACRO will not work in my new windows 8.1 and Office 201
While you are at it, you could inquire from the developer if they have any suggestions to fix the sheet too.
Regards,
Rudi
If your absence does not affect them, your presence didn't matter.
Rudi
If your absence does not affect them, your presence didn't matter.
-
- NewLounger
- Posts: 24
- Joined: 04 Dec 2015, 17:06
Re: MACRO will not work in my new windows 8.1 and Office 201
it works now....apparently I saved it as a 'XLSM' spreadsheet and all is well.....THANK YOU for all your help. Much appreciated
-
- Administrator
- Posts: 78665
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
-
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Re: MACRO will not work in my new windows 8.1 and Office 201
Excellent. Glad it is resolved.
Regards,
Rudi
If your absence does not affect them, your presence didn't matter.
Rudi
If your absence does not affect them, your presence didn't matter.