• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Problems with xlsb format

mehman

New Member
I have a template in xlsb format ( lets call this t.xlsb) that I use to create reports using Access 2007 & vba. This template has 2 sheets, each with a pivot table.


Whenever I make changes to the template and run the reports, the reports get corrupted. So I do the following steps

1. save the template as another one (lets call this one the t1.xlsb).

2. Rename t.xlsb to new.xlsb.

3. rename the t1.xlsb to t.xlsb

4. delete new.xlsb.


I repeat these steps every time I make changes to the template, to avoid corruption of reports.


Any suggestions to avoid these 4 steps after making changes.


Thanks in advance.
 

Hui

Excel Ninja
Staff member
Mehman


Backup the file

Open the file

Ctrl+Alt+Shift+F9

Save the file

Close excel

Open the File


See if that helps


If that doesn't

When you open the file, select File Open

Select the file Don't press Open

Select the small drop down arrow next to Open

Select Open & Repair


See if that helps
 
Top