I have solved the problem by saving the original XLS as XLSX and all problems are gone.
Thank you very much for the help.
Search found 7 matches
- Mon May 04, 2020 7:51 pm
- Forum: PlanMaker 2018 for Windows
- Topic: Reference to other workbooks message
- Replies: 4
- Views: 8674
- Mon May 04, 2020 6:59 pm
- Forum: PlanMaker 2018 for Windows
- Topic: Reference to other workbooks message
- Replies: 4
- Views: 8674
Re: Reference to other workbooks message
I can not send you the worksheet as it has 4 pages of personal data in it.
This is the same file that had the hiding columns and rows problems (solved by saving the file as XLSX)
This is the same file that had the hiding columns and rows problems (solved by saving the file as XLSX)
- Mon May 04, 2020 5:53 pm
- Forum: PlanMaker 2018 for Windows
- Topic: Reference to other workbooks message
- Replies: 4
- Views: 8674
Reference to other workbooks message
When I open a worksheet i get this message: This workbook contains references to other workbooks. Do you want to update these references. I have searched thru all the pages in the workbook, and corrected all references, but i still get the message. Is there any way of finding what the message is ref...
- Mon May 04, 2020 5:46 pm
- Forum: PlanMaker 2018 for Windows
- Topic: Hiding multiple columns and rows
- Replies: 6
- Views: 10107
Re: Hiding multiple columns and rows
Seems to be working as an XLSX file.
Thanks for the help.
Thanks for the help.
- Mon May 04, 2020 4:55 pm
- Forum: PlanMaker 2018 for Windows
- Topic: Hiding multiple columns and rows
- Replies: 6
- Views: 10107
Re: Hiding multiple columns and rows
I can not send you the worksheet as it has 4 pages of personal data in it, So I Tried copying the pages to a new worksheet and then hid the worksheet rows and columns closed and reopened it and the rows and columns stayed hidden. But Could the problem be causes by the fact that the problem worksheet...
- Mon May 04, 2020 1:51 pm
- Forum: PlanMaker 2018 for Windows
- Topic: Hiding multiple columns and rows
- Replies: 6
- Views: 10107
Re: Hiding multiple columns and rows
That is exactly how I am hiding columns and rows and I end up with what i wrote in my question.
- Sat May 02, 2020 1:37 pm
- Forum: PlanMaker 2018 for Windows
- Topic: Hiding multiple columns and rows
- Replies: 6
- Views: 10107
Hiding multiple columns and rows
Is there a limit in the number of columns and rows which will remain hidden after closing and reopening Planmaker? In My case I am hiding, Column M to end and rows 36 to end. but on reopening the worksheet: only columns 36 to IV are hidden and only Rows 36 to 88 are hidden Is this a bug or restricti...