ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   using % button gives error "percent style not found" Can I reset? (https://www.excelbanter.com/excel-discussion-misc-queries/77386-using-%25-button-gives-error-percent-style-not-found-can-i-reset.html)

Light

using % button gives error "percent style not found" Can I reset?
 
My percent toolbar button was working fine, but suddenly it has started
giving me the error message percent style not found. Can I get it to work
again?

Dave Peterson

using % button gives error "percent style not found" Can I reset?
 
Start a new workbook.
Check to see if the percent style button works in that new workbook.

If it works there, you can activate the problem workbook
format|style|Merge and "steal" that Percent style from that new workbook.

Styles live in workbooks. So if you used this problem workbook as a basis for
other workbooks, you may have to repeat this process for those workbooks, too.


Light wrote:

My percent toolbar button was working fine, but suddenly it has started
giving me the error message percent style not found. Can I get it to work
again?


--

Dave Peterson

Light

using % button gives error "percent style not found" Can I res
 
Yes, the problem seems to be workbook specific, so I think I'll cheat and
just copy all my data over to a new workbook. That's a relief!
Thanks for the help.

"Dave Peterson" wrote:

Start a new workbook.
Check to see if the percent style button works in that new workbook.

If it works there, you can activate the problem workbook
format|style|Merge and "steal" that Percent style from that new workbook.

Styles live in workbooks. So if you used this problem workbook as a basis for
other workbooks, you may have to repeat this process for those workbooks, too.


Light wrote:

My percent toolbar button was working fine, but suddenly it has started
giving me the error message percent style not found. Can I get it to work
again?


--

Dave Peterson


Dave Peterson

using % button gives error "percent style not found" Can I res
 
I would think that it would be much easier to merge the style than to set up a
new worksheet.

Light wrote:

Yes, the problem seems to be workbook specific, so I think I'll cheat and
just copy all my data over to a new workbook. That's a relief!
Thanks for the help.

"Dave Peterson" wrote:

Start a new workbook.
Check to see if the percent style button works in that new workbook.

If it works there, you can activate the problem workbook
format|style|Merge and "steal" that Percent style from that new workbook.

Styles live in workbooks. So if you used this problem workbook as a basis for
other workbooks, you may have to repeat this process for those workbooks, too.


Light wrote:

My percent toolbar button was working fine, but suddenly it has started
giving me the error message percent style not found. Can I get it to work
again?


--

Dave Peterson


--

Dave Peterson


All times are GMT +1. The time now is 06:57 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com