excel found unreadable content do you want to recover the contents of this workbook

M

manojhsn

New Member
Joined
Jun 12, 2009
Messages
18
Hi Everyone,

I am developed an excel template using macros. Once the template is run, save and closed, the next time while opening the template I am getting this message - "excel found unreadable content do you want to recover the contents of this workbook".

Again I remake the whole template once again but still the same thing is happening. Finally I got the point which causes this problem. i.e I am using a method to update equations/formulas for a worksheet in my template. If I comment this method and run, template is working fine and next time while opening I am not getting this message.
But I want to keep this method to update the formula. Please help me to resolve this issue.

Thanks in advance.
Have a nice day. :)

- Manu
 

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying
Sort by date Sort by votes
Hello Everyone,
I got solution to my problem. There is an error with the equation which I was putting into the cell through Macro.
The faulty equation was - "=IFERROR(VLOOKUP($E3, INDIRECT(CONCATENATE(ADDRESS(AZ$1,5,,,Cost Center 'FY09'), ":", ADDRESS(BA$1,24,,,))),20,FALSE),0)"

Formula Address should provide with the sheet name in double codes as "Cost Center FY09" but instead it was writing it as Cost Center 'FY09'. And I was doing writing this equation through Macro.

Thanks & Regards,
Manoj.:)
 
Upvote 0
You must log in or register to reply here.

Similar threads

C
  • Solved
Need help for searching...
Replies
7
Views
393
Callamity
C
D
  • Question
Excel on Mac - file repair issues
Replies
1
Views
1K
dskills
D
G
  • Solved
Saving a Excel workbook with folder and filename from range of cell contents
2
Replies
14
Views
1K
garthkh
G
S
  • Question
excel file saved in computer with older version excel
Replies
6
Views
427
Shloime
S
M
  • Question
How to copy contents of open workbook to current workbook
Replies
1
Views
354
rlv01
R

Forum statistics

Threads
1,214,606
Messages
6,120,492
Members
448,967
Latest member
visheshkotha

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top