topic Re: Problem with Reports in Civil 3D Forum

Problem with Reports

Robplatt — Thu, 01 Dec 2022 04:39:33 GMT

I have upgraded to Civil 3D 2023 and I'm now having trouble using Reports Manager (Toolbox) to generate Excel reports. I know this has come up in previous discussions, but I wonder if there are any updates. Both Civil 3D and Excel are fully up to date. I can create a report to HTML, but that isn't what I need.

See screenshot:

Re: Problem with Reports

Matheus-Lima — Thu, 01 Dec 2022 22:13:02 GMT

Hi, @Robplatt!

I have here Civil 3D 2022 and 2023, and both have this issue with reports in Excel. I usually generate the report in HTML, open it, control + A to select everything, copy and paste it in cell A1 in Excel. From this point, I have some macros and formulas in Excel to do the job. Perhaps this workflow helps you.

Cheers,

Re: Problem with Reports

Robplatt — Wed, 07 Dec 2022 01:45:32 GMT

@Matheus-Lima

Thanks for your reply.

I’ve also been using HTML as a way to get around it, or Select all, copy and paste from Project Explorer.

The problem is that this doesn’t actually “fix” the issue.

Well - hopefully AutoDesk will take note and send out an update …….

Cheers.

Re: Problem with Reports

Robplatt — Tue, 13 Dec 2022 08:10:57 GMT

Hi again.

I posted this to Autodesk and they tried to replicate the problem using my data. They couldn’t replicate it so they suggested I should try to run a repair on Office 365, and/or do a clean reinstall of Civil 3D. I did the Office 365 repair process and now the problem has vanished.

Worth an try if anyone has the same issue.