Excel - Overwrite Specific Tabs

Question

Hi All,

I'm overwriting some of the tabs in my excel workbook and whenever i open the output file i get this message and specifically around  'Sheet 13'.

""We found a problem with some content, do you want us to try to recover as much as we can?""

The one thing  i could see in 'Sheet 13' there are some couple of text fields which has got some truncated characters is this causing a problem?

I tried lots of search and i couldn't find any solutions.

Thanks

MattBSlalom · Answer

I'm not familiar with the error message, but I wonder if it's an issue with some of those special characters in the text values (like the bullets).  Have you tried wrapping those values in an Excel formula syntax?  So instead of writing:

1. some text

it becomes:

="1. some text"

Alternatively, it may be worth trying to replace variations of the bullets to a known version that writes successfully like the hyphen "-".

suby · Answer

Hi,

Sorry unfortunately i cant provide the data due to security reasons but i have mocked up the data some of the column hold values as below.

Column 1column 2Column 3Column 4Column 51. some text [1] Some Text[1] Some Text: ·

-Some Text.
-some TextSome Text.
• Some Text.
• Some TextThe "some text" must :
- Some text.
- Some text1)    some text

Thanks any pointes would be much appreciated.

Thanks

Emmanuel_G · Answer

@suby

Is it possible to provide even a sample of the content that goes into sheet 13 for testing?